Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extract data from CSV and update in Sql server table

Status
Not open for further replies.
tumtoo10

tumtoo10

Programmer
Dec 10, 2001
40
US
I need to extract data from a csv file and show it in a grid and then update it in a MSSql server table.I was trying the same with data control + data grid. But no success. It is working for excel file but not for CSV.What should be the connect option be set to in case of CSV, which i set excel8.o; in case of excel file. Also I will be getting the file name at runtime.
Any other way to do the same.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Copy data between SQL and Oracle
Replies
5
Views
99
dhookom
dhookom
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
406
strongm
strongm
kris gersbach
  • Locked
  • Question
I’m importing a csv into a vfp curs
Replies
1
Views
141
Andrzejek
Andrzejek
monyi
  • Locked
  • Question
Extracting Data from XML Node
Replies
0
Views
113
monyi
monyi
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
190
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top