By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,714 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,714 IT Pros & Developers. It's quick & easy.

Copy data from a csv or xls file

P: n/a
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
Oct 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Oct 16 '07 #2

P: n/a
FileHelpers
http://www.filehelpers.com/
Tony A. wrote:
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...
Oct 17 '07 #3

P: n/a
Jay - Thank you, very helpful...
--
Tony
"jay parzych" wrote:
FileHelpers
http://www.filehelpers.com/
Tony A. wrote:
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...
Oct 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.