• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Cannot import csv file into sql

Hi,

I am trying to import a csv file into sql server. I have a datagrid which displays these fields on the frontend:

Invoice Date
SO #
PO #
Carrier
Package #
Tracking #

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!
0
stevegingell
Asked:
stevegingell
1 Solution
 
SystemExpertCommented:
Hi,

This is the Link where they have given code as well as interface so you will have idea what will be done

http://www.codeproject.com/cs/database/FinalCSVReader.asp

Thanks
0
 
stevegingellAuthor Commented:
This link was more complicated than what I needed. I decided to go another route. Thanks anyways
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now