Copy data from a csv or xls file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to read data in either a csv or xls file and save each row as a record
in a SQL Server 2005 Express database. Do you have any suggestion on where I
can find examples of code that can do this? Thanks...
 
Tony,

Just look at Internet (Google groups are the best in my idea for your
question) to OleDB csv or OLEDB excell. You will get about 10000 answers on
your question.

Here a place to start.

www.connectionstrings.com


Cor
 

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

Macro to open CSV files 6
How to open a .CSV file ? 22
How to import and export data? 1
writing to a csv or fixed format text file. 4
COnverting CSV to XLS file 5
Processing CSV Files... 2
Load a CSV into an empty, formatted XLS? 15
import data from csv file 9

Back
Top