Hi @teeboy1 ,
Did you try to use Import Flat File to SQL Wizard? Refer to Import Flat File to SQL Wizard to get more information.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have a .tab file to import to SSMS but when I do successfully, it shows all data types as varchar, which isn't supposed to be.
Any fix for this? Thanks.
Hi @teeboy1 ,
Did you try to use Import Flat File to SQL Wizard? Refer to Import Flat File to SQL Wizard to get more information.
If the response is helpful, please click "Accept Answer" and upvote it, thank you.
You will be much happier if you always import data into varchar fields in a "staging" table, and then use insert or update or merge to move the data into the target tables. You will have much more control over the data conversion.