Looking to Insert Text File into DB Table with extra columns
Posted on 2003-10-22
I won't bother posting my lame attempts at solving this, it will probably just slow things down.
Its just a regular tab-delimited text file - it looks basically like this:
MODEL UPC ISBN
A15 111111 233333
B37 234556 234233
And the table (currently in Access 2000, moving to SQL 2000 before it goes live probably) has extra columns b/c some text files will have more or less columns. So its something like:
MODEL MANUFACTURER UPC ISBN PRICE (etc)
What I'm trying to do is take the text file and insert all the records into the table, with the fields of course matching up. What is the best way to do this? The text files will be replaced on a regular basis, and so I don't want to set it up as a datasource if that's an option.