change two lines of text data to one
 

when i extract data from a data base in text form, each record is on two
lines. Every record is comprised of a number of fields separated by spaces.
How do i spread each record onto a single line so that I can work with each
individual field in access.

Instead of exporting a text file, and opening it in Excel, maybe you can
import directly from the other database to Access.

the turtle wrote:
when i extract data from a data base in text form, each record is on two
lines. Every record is comprised of a number of fields separated by spaces.
How do i spread each record onto a single line so that I can work with each
individual field in access.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html