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
0
0
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
  • Question
Outlook Template replace text 2
Replies
13
Views
934
Andrzejek
Andrzejek
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
117
linuxguyEastCoast
linuxguyEastCoast
feipezi
  • Locked
  • Question
Do we have a VBS version of listing files in a folder?
Replies
2
Views
72
strongm
strongm
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
150
strongm
strongm
Andrzejek
  • Locked
  • Question
Retain signature in Outlook
Replies
17
Views
214
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top