Hello All:

I have to code this utility to read an ASCII file and putting the data into
MS Access tables. My question is:

1. Is it possible to read ASCII files and extract the data from it using MS
Access.
2. If yes, how do I read the characters at specific locations (like
characters 10-15 of record 1)

It will be of great help if someone can help me with the canned code written
for these kind of utilities. I have to be real quick at this.

Thanks
Ajay Jain

Ajay

Here is an example on reading a txt file.

Dave

========

Sub ReadIt()

Dim aString As String
Dim aLine As String

Open "c:\my documents\input.txt" For Input As #1

Do While Not EOF(1)
Line Input #1, aLine

aString = Mid$(aLine, 1, 5)

Debug.Print aLine
Debug.Print aString

Loop


End Sub



----- Original Message -----
From: "Ajay Jain" <ajain@i...>
To: "Access" <access@p...>
Sent: Tuesday, May 28, 2002 5:37 PM
Subject: [access] Reading ASCII Files


Hello All:

I have to code this utility to read an ASCII file and putting the data into
MS Access tables. My question is:

1. Is it possible to read ASCII files and extract the data from it using MS
Access.
2. If yes, how do I read the characters at specific locations (like
characters 10-15 of record 1)

It will be of great help if someone can help me with the canned code written
for these kind of utilities. I have to be real quick at this.

Thanks
Ajay Jain