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!

Insert txt file into a sql server compact edition database

Status
Not open for further replies.
JackBurton07

JackBurton07

IS-IT--Management
Oct 17, 2007
75
0
0
GB
Hi

I want to enter a text file with around 1300 rows/6 columns of comma separated values into a sql server compact edition database however normal sql commands dont seem to work.


Does anyone know the correct sql syntax for this in vb 2005?

Thanks!
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
107
muaricewayne
muaricewayne
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
101
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
65
sal21
sal21
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
192
strongm
strongm
sal21
  • Locked
  • Question
read xml file 1
Replies
9
Views
127
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top