I am trying to import a delimited flat file data source into a table that I have created with the desired attributes using SQL Server Management Studio. I started by exporting the table as a flat file. Then I created the table definitions on the new database. Then I imported the flatfile source into my new table but it gives me an error that the table is already defined. If I don't define the table ahead of time, the flat file will just create a varchar(50) attribute for every field item. So how can I import a table from a delimited flat file into a table with an existing definition so I can retain the proper field definitions? Dave
I am importing under the tasks menu item as a flat file which only has comma delimited data. I am not running any script. I know that in MYSQL you can use a LOAD DATA INFILE command but there is no such command that I know of in Microsoft SQL. I tried to use a LOAD DATA INFILE command in a script and got an error. Is there an SQL script command that allows me to upload data from an input file?
How can I specify Import field constraints?
Posted - 12/30/2012 : 13:05:45
