Importing data

  • Thread starter Thread starter Moulthrop
  • Start date Start date
M

Moulthrop

I am trying to import data from an old DB program (ORGANIZE!). Dat
imports but only on first row, all the way to column IV. Please advis
if there is a way to import and use all subsequent rows after end o
each entry. Thank you
 
Excel can only handle 256 columns.
Try setting up a query via Data/Get External data (data import) to
exclude some columns.
 
Original data I am trying to import has 12 lines per entry. Whe
importing, Excel did not start a new line at beginning of each entry
 
Quite a small file then ? Try opening the file in Notepad or Window
Write, or even Word so you can see the data. You might be lucky an
find it is mainly a text file. If there is some pattern to the dat
(eg. start and finish point) it might import as a binary/text file o
be open to some other macro manipulation.

I use a text editor called TextPad and it is excellent in that it show
binary code and text sisde by side
 
Back
Top