| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
| Pie chart with 'anchored' lines to text box | Charts and Charting in Excel | |||
| can't change how data on 2nd axis is being displayed | Charts and Charting in Excel | |||
| Wrap text cuts-off after several lines | Excel Discussion (Misc queries) | |||
| create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
Hybrid Mode
