change two lines of text data to one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem with fractions to decimal 1
split post code (zip code) out of cell that includes full address 4
data from multiple files: best way to extract 1
Change all text on Spread sheet 1
Spreadsheet with data on two lines 3
Converting irregular Word table to spreadsheet 4
merging two large spreadsheets 2
Macro 1

Back
Top