Import HTML and Tab delimited into SQL -- sql server odbc

Eric
12/9/2004 3:29:01 PM

Hi,

I need to import files from either HTML or Tab delimited format into SQL
Server. I imagine this would involve DTS and/or a DSN, but I'm not sure of
the details. I'm able to standardize the filename and directory using code,

Robbe Morris
2/3/2005 10:07:03 PM

HTML? I don't think so. Tab delimited, you bet.
Yes, you would set up a DTS packages using the
Import / Export wizard.

If you want to script this and run it, check out this
VBScript code sample:

http://www.eggheadcafe.com/articles/20030923.asp

--
2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net
http://www.mastervb.net

[quoted text, click to view]

sql server odbc : Import HTML and Tab delimited into SQL