Cannot import csv file into sql
Posted on 2006-04-20
I am trying to import a csv file into sql server. I have a datagrid which displays these fields on the frontend:
These are pulled from the ShippingData table in sql server. I need an import functionalty on the admin (backend) side. Here every morning a tech would first browse, the attach a csv file and then hit export. On successfully importing, it should append the data into the ShippingData table, and not overwrite it.
Basically this process is repeated every morning, the "Invoice Date" would be today's date. And the datagrid would show the records only with today's date. The older ones would just not show - but still be in the database, as i am also building a search function which can search through older data. Also i need to write evrything asp.net as I am not looking for a DTS package.
I have to get this done by tonight so any help will be greatly appreciated!