
Import text file in SQL Server 6.5 via SQL in Visual Basic
I am attempting to import a textfile into a SQL Server 6.5 table through
Visual Basic. I can do this easily in Access using a command like this:
INSERT INTO <tablename> SELECT * FROM
[text;database=<TextFileDirectory>;dsn=<Specification file>;
imex=2;hdr=no;fmt=fixed].[<TextFileName>#txt]
<tablename> = table in Access
<TextFileDirectory> = directory where text file exists
<Specification file> = Specification file defined in Access
<TextFileName> = Name of text file
Is there a similar SQL that I can use to make it work in SQL Server as
well. Any suggestions are welcome.