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!

Reading in Text Files

Status
Not open for further replies.
pparadis

pparadis

MIS
Dec 5, 2000
22
US
I'm using INPUT to read in a text file to Access and write data to tables. Currently I am reading one piece of data per text line(one record can take up multiple lines). Is there any way to read one record per text line and seperate attributes by say a semi-colon or some other symbol?

Thanks.

 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Outlook Template replace text 2
Replies
13
Views
1K
Andrzejek
Andrzejek
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
212
sal21
sal21
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
249
linuxguyEastCoast
linuxguyEastCoast
feipezi
  • Locked
  • Question
Do we have a VBS version of listing files in a folder?
Replies
2
Views
118
strongm
strongm
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
396
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top