Importing Fixed Width Text File

[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

 

[Guest]

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.

 

[Guest]

Thanks, that is much appreciated!!!

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.