importing data using a macro

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
0
Jo
8/20/2003 8:57:15 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
679 Views

Similar Articles

[PageSpeed] 43

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.

"Jo" <joany@02.ie> ????? news:0b3a01c366f9$0d401820$a301280a@phx.gbl...
> 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


0
jharvest (8)
8/20/2003 9:08:51 AM
On Wed, 20 Aug 2003 17:08:51 +0800, "Eddy" <jharvest@ctimail.com>
wrote:

>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?

>"Jo" <joany@02.ie> ????? news:0b3a01c366f9$0d401820$a301280a@phx.gbl...
>> 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


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
0
ApolloXVIII (173)
8/20/2003 9:35:19 AM
Reply:

Similar Artilces: