change two lines of text data to one

T

the turtle

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.
 
D

Debra Dalgleish

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