csv files to ms sql using asp 1

[b00gieman]

Hi!
Does anyone know how to export .csv files into a table using asp?
thanks in advance

 

[ChrisHirst]

export from a table

or

import into a table ????


"export into" is a contradiction in terms where csv & databases are concerned.


Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[onpnt]

BCP Utility

But then again export/import, upload/download blah, balh needs clarification as Chris stated

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]

 

[b00gieman]

Sorry.What I want to do is to import data from a csv file into a sql table

 

[onpnt]

Not sure why that tgml broke. maybe the +'s. Anyhow look into calling bcp to literally slame the csv into the table. This will be your fastest performaing solution. If your sql server has openrowset enabled you can also use it to grabt the csv and pull the data into sql server.

Avoid and I stress "Avoid" parsing the csv and sending hundreds if not thousands of inserts to the database. This is horribly bad and not needed. You should use the database servers provided tools to pick the best one.

[sub]____________ signature below ______________
You are a amateur developer until you realize all your code sucks.
Jeff Atwood[/sub]