loading data from file to db

A

AVL

Hi,
I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

which is the best approach to load the daat wrt performance...

as of now, i'm planning to populate into a dataset and loop through the
dataset
record by record and update into the db..is there any other alternative?
 
S

sloan

Do you need to run any rules on the data BEFORE insert?

Or is it a "dumb" insert? (Copy no matter what, the source data is
"perfect").
 
A

AVL

Yes, I need to validate data before uploading

sloan said:
Do you need to run any rules on the data BEFORE insert?

Or is it a "dumb" insert? (Copy no matter what, the source data is
"perfect").
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

laoding data from csv file 2
Error while updating data through dataset 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Loading TXT to DB (VB) 5
XML File processing 2
Set TableAdapter connection to XML file 0
Loading ado.net table from datatableReader - wont update table on 2
serializing dataset with huge data 2

Top