Working with large daily updates on database

[hallm]

I'm in the starting process of building on online database that will store computer prices for computer assemblies and computer parts that will be used for an online store. I will virtually have one vendor for all of the parts that gives a daily zipped file with complete updates the file is comma-delimited with quotation marks on text fields. The file is complete every day, so that you can just replace the old file with the new one to update the database. What is the best option to work with this? I'm more familiar with asp programming. But is this the best way to work with this type of a database. Do you import the text file to an access or sql database or do you leave it in a text file format? I would like to also look into automating the process one day. Is that possible?

 

[DannyB]

I'd say you better either make a component to do that, or use a VB program.

With the component, you could it from an asp page.

 

[palbano]

Dear hallm,

You might want to look at SQL Server 'BULK INSERT' statements before proceeding. As of SQL 7 they are available through external interfaces like ADO making it simple to automate.

Good luck
-pete

 

[nalbiso]

SQL will allow you to automate importing the text file. You can set up a job
to import that text file and then schedule it for as often as you want the
file imported.

You may also use job scheduling for the inserting process.