Hello everyone,
This is my first post on this site. I have a question for you fellow experts. I have an excel file that I want to import into Microsoft SQL Server 2016. I know how to do the basic steps but I want to do one more thing. When I import it through the importer this is what its doing, I have three data types that are suppose to be 'date' however once I do the importing and not do the edit mapping its importing those data types as strings. I do not want to go to edit mapping all the time to fix that issue. Is there a way code or other wise any other solution to fix that issue? Thank you everyone.
This is my first post on this site. I have a question for you fellow experts. I have an excel file that I want to import into Microsoft SQL Server 2016. I know how to do the basic steps but I want to do one more thing. When I import it through the importer this is what its doing, I have three data types that are suppose to be 'date' however once I do the importing and not do the edit mapping its importing those data types as strings. I do not want to go to edit mapping all the time to fix that issue. Is there a way code or other wise any other solution to fix that issue? Thank you everyone.
