Import only shows sample of 25 rows

E

EA

I am trying to import a large text file into Access. The import wizard shows
only the first 25 rows. The text file format changes below the 25th row. I
can not parse the file correctly without seeing these rows. When importing
to excel, I am able to see the whole text file. However, excel is limited to
65k rows and I need more. Is there any way to see the whole text file when
importing into access?
 
G

G. Vaught

If your format changes below the 25th row, then importing to Access would
not work anyway. The data has to be all in the same format in order to
import directly as a text file. If you can't import the entire text file
into Excel, then you need to break-up your text file into smaller text files
so that you can. It is much easier to import from Excel to Access than a
text file to Access.
 
J

John Vinson

I am trying to import a large text file into Access. The import wizard shows
only the first 25 rows. The text file format changes below the 25th row. I
can not parse the file correctly without seeing these rows. When importing
to excel, I am able to see the whole text file. However, excel is limited to
65k rows and I need more. Is there any way to see the whole text file when
importing into access?
Click to expand...

I would suggest extracting a *representative* section of the file and
use it to set up and save an Import Specification. You can then use
that stored specification to import the entire file.

You may be best off creating a table with the desired datatypes and
field sizes; then use File... Get External Data... Link to link to the
text file (using the stored spec) and an Append query to populate your
table.

John W. Vinson[MVP]
 
Top