asked on

Create Text Export Specs For Access Text Export

Hi Everyone,

Is there a way that I can create export specifications for a text file that I want to export from Access, independent of using the text export wizard in Access? Ideally, I'd like to create a text file that states where to start and the width of the columns for each field and then use that file as the specification for the export.

Any guidance on this would be very helpful.

Thank you.

-Anthony

Rey Obrero (Capricorn1)

< independent of using the text export wizard in Access?>
why?

<Ideally, I'd like to create a text file that states where to start and the width of the columns for each field>

there is an option (fixed width) to do this using the wizard..

Anthony

ASKER

Hi Rey,

There are two reasons...

1. I will need this file export for about 8 different Access programs, and it becomes easier to just alter the text document that is used to generate the file versus having to respec out the file each time.

2. It's easier to make a change to the independent text file versus going through the wizard.

I am aware of the wizard for fixed width, as I've been using it; however, I think it would be more efficient if I can create a base file that can be used for the export itself.

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Anthony

ASKER

Ah ok, I was more so hoping that I could just point to this text file via vba using the export function...

ASKER CERTIFIED SOLUTION

PatHartman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial