Import to SqlServer
-
I got a text file that i exported from SQL Wizard and i named bank.txt. i want to write out a program that allow to import bank.txt file to SQL Server but i do not know how to do it. So can anyone help me or show me where to get the source code. Thank a lots. quoc
-
I got a text file that i exported from SQL Wizard and i named bank.txt. i want to write out a program that allow to import bank.txt file to SQL Server but i do not know how to do it. So can anyone help me or show me where to get the source code. Thank a lots. quoc
Hi, Try reading your textfile using the "streamreader" and save it one at a time using the INSERT statement into your SQL server. IF your text file is big or you often do it, might as well use the DTS in #C. I haven't tried it but I know it will work. /dabuskol