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.
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.
Hello, it was downloaded as a .tab file.
I imported from SSMS via Tasks -> Import Data -> Flat file
It seems that the file does not contain type information, but you can specify the desired types manually in the corresponding dialog.
Hi @teeboy1-7818,
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.
I tried that as well, got the error in the link and can't find my way around it
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.
Thanks, so Bulk Insert would be the go-to way?
After creating an empty table with the datatypes I need
8 people are following this question.
Year and Month aggregation in same Pivot table in SQL Server
SQL Server Query for Searching by word in a string with word breakers
How to show first row group by part id and compliance type based on priorities of Document type?
Query to list all the databases that have a specific user
T-sql query to find the biggest table in a database with a clustered index