[thelist] ODBC Text File Driver and ASP

[Simon Davies]

Hi

Why do you need to drop the table? If you need to clear its rows why not use
Truncate instead. You would still have to drop the indexes if they are
slowing the upload though.

Simon

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Anthony Baratta
Sent: Tuesday, 28 November 2000 08:07
To: evolt Mailing List
Subject: [thelist] ODBC Text File Driver and ASP


Howdy!

I'm looking to solve a current problem I have to auto load a very large
amount of
data daily. (Basically drop and re-create the target tables, import the
data, and
create the indexes.) Side Note: the data files might need massaging prior to
importation, e.g. a header row and cleanup of the file to remove "bad data"
lines.

One option is to use the Bulk Copy program, but I think this may be unwieldy
via
VBS/ASP.

Another option I thought of today was to use the MS ODBC Text File Driver
and talk to
it like a database with SQL.

So the question is: Has anyone done this before? Or have a better solution?

--
Anthony Baratta
President
KeyBoard Jockeys
                    South Park Speaks Version 3 is here!!!
                       http://www.baratta.com/southpark
                              Powered by Tsunami

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !