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
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
  • Question
merge .txt in one named big.txt 1
Replies
10
Views
380
sal21
sal21
sal21
  • Locked
  • Question
Replace , with ; in txt file
Replies
7
Views
204
muaricewayne
muaricewayne
Niki_S
  • Locked
  • Question
How to insert excel sheet into sql server using vb 6?
Replies
6
Views
209
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
delete first line in txt and rewrite
Replies
2
Views
125
sal21
sal21
2009luca
  • Locked
  • Question
graph with access database - im on vb6 2
Replies
10
Views
431
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top