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

Read fields from .txt file and write to a table

P: 1
Hi,


I have a text file as follows:

a1,b1,c1,d1,09,32,d1
b2,c2,x1,d1,98,21,x1
s1,w2,e3,c4,78,56,c1

I want to read this .txt file and write to an Access table using VB6 coding.

Please help me to solve this as soon as possible.

RGDS.

Chaan.
Nov 29 '07 #1
Share this Question
Share on Google+
2 Replies


hariharanmca
100+
P: 1,977
Is every comma is your field?
Nov 29 '07 #2

Expert 5K+
P: 8,434
You could use the text file import built into Access (pretty sure you can drive it from your code). But I think what Hari is getting at is that if you know that the commas only appear between your fields and not in the data, you can use the Split() function to split the text into an array based on the commas.
Nov 29 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.