Importing Fixed Width Text File

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

Guest

Hi All,

I have a file that is text and I wish to use the Import wizrd, the file is
of a fixed width type, once I have defined that number of characters per
column once, is it possible to automate this so I can import further files
without having to set out the widths again. Thanks
 
Yes, when you are in the wizard, look for the Advanced command button. Click
on that and define the field names, sized, etc. Then click on Specs and give
it a name. Then you can use VBA, or a Macro to do the import. See the
TransferText method in VB Help for how to use the spec name in an import.
 
Thanks, that is much appreciated!!!

Klatuu said:
Yes, when you are in the wizard, look for the Advanced command button. Click
on that and define the field names, sized, etc. Then click on Specs and give
it a name. Then you can use VBA, or a Macro to do the import. See the
TransferText method in VB Help for how to use the spec name in an import.
Click to expand...
 
Back
Top