Importing Fixed Width Text

[Duane]

I have a text file that I would like to import into a table using a macro,
but I am having difficultly understanding the help file.

1. Selected TransferText from the Action Window.
2. Transfer Type = Import Fixed Width
3. Specification Name ??????
4. Table Name = Test
5. File Name = C:\Temp\175updt.txt
6. Field Names = No

I am confused with the Specification Name. I have read the help file but I
am unsure what arguement to use and the schema.ini thing lost me. Sure
would appeciate some assistance.

Thank you

 

[Graham Mandeno]

Hi Duane

Do the first import by hand, using File->Get external data.

After you have specified all the field names and types and widths, click the
"Advanced" button, and save the specification with a meaningful name.

Then you can use the name in place of ??????.

 

[Duane]

Thanks Graham! It was much easier than I thought it would be.

Hi Duane

Do the first import by hand, using File->Get external data.

After you have specified all the field names and types and widths, click
the "Advanced" button, and save the specification with a meaningful name.

Then you can use the name in place of ??????.
--
Good Luck

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a text file that I would like to import into a table using a macro,
but I am having difficultly understanding the help file.

1. Selected TransferText from the Action Window.
2. Transfer Type = Import Fixed Width
3. Specification Name ??????
4. Table Name = Test
5. File Name = C:\Temp\175updt.txt
6. Field Names = No

I am confused with the Specification Name. I have read the help file but
I am unsure what arguement to use and the schema.ini thing lost me. Sure
would appeciate some assistance.

Thank you