importing data using a macro

[Jo]

hi
i wish to import 300 fields of data into a spreadsheet
from a text file, but since spreadsheets are only 250
fields wide. i was wondering if there was anyway of
writing a macro that could import the data vertically, so
its all in one column or transpose it during
importation. the cut and paste method is possible but i
have 200 of these text files to import into this
spreasheet and don't think this method would be best.
thank you time and any effort that you spend on this
matter its been much appreciated
Jo

 

[Eddy]

I suggest you use Access to do this kind of job. With Access, you can
easily select any of the 300 fields for report or export to Excel worksheet.

 

[Hank Scorpio]

I suggest you use Access to do this kind of job. With Access, you can
easily select any of the 300 fields for report or export to Excel worksheet.

Ummm... no. An Access table has a maximum of 255 fields. See the
on-line help topic "Access Specifications". Access can be used to get
around Excel's rows limitation, but not its column one.

As for Jo's question, it's possible... but before starting on this
path can you be certain that the number of records in each file is
<=256?