Importing fixed-width text (1 Viewer)

C

cabi

Guest

• Feb 24, 2003

• #1

I have several text files that I would like to import using the the same macro into the same table. Is there a way to create a macro to prompt me as to which file to import (in the File Name section)?

 

FoFa

Registered User.

Local time

Yesterday, 18:48

Joined

Jan 29, 2003

Messages

3,672

• Feb 25, 2003

• #2

Create a popup form requesting the data, with a command button on that form, use an event procedure to DOCMD.TRANSFERTEXT and pull the file name from the popup form.

 

C

cabi

Guest

• Feb 25, 2003

• #3

I created the popup form and created the button to call up the popup form, but how do I request the for the list of text files in a windows directory?

Thanks for your help.

 

FoFa

Registered User.

Local time

Yesterday, 18:48

Joined

Jan 29, 2003

Messages

3,672

• Mar 3, 2003

• #4

Search the web and look for an example of common dialog routines for the version of Access you are using. Then import that code. It is usually pretty straight forward.