Text file Import: only 25 rows available

[barboza]

We are trying to import a text file. We are having two problems.

First a little history about the text file:

The text file contains results of a lab test. The data of interest does not appear before row 50 of the text file. The text import wizard in access does not show any rows after row 25.

Problem 1: How can I know wear to put column breaks if I can't scroll down far enough to display the data of interest.

Problem 2: How would I get rid of the top 50 rows of superfluous text?

Thanks.

 

[jdraw]

Read the data into a table, then use 1 or more queries to manipulate the data you need.

 

[spikepl]

Read this thread http://www.access-programmers.co.uk/forums/showthread.php?t=219430

 

[gemma-the-husky]

if you "know" the layout of the table, you can set the columns based on the ruler positions.

 

[barboza]

There are several pieces of data that need to be extracted from the text file. I like the idea of reading the entire file into a table, then manipulating the data.

Thanks to all of you that took the time to respond. Much appreciated!