Import Text file using TransferText Action

[Guest]

Hi:

i'm trying to IMPORT data from a text file using a Macro and transfer text
action. When I select Transfer type: Import Fixed Width, I'm not sure what
to put in Specification name.

I want this string of data to be loaded into 6 columns.
01-00-205-000-1250-00-0000
1010-1205-0000-125000-00000-00 .00
14,828.37 .00 14,828.37

Please of a ny solution.
Thanks for your help
Lourdes

 

[tina]

*you* create the import specification, and name it anything you want. to set
up an automated import using a macro, start by importing the text file
manually via File|Get External Data|Import from the menu bar. when the
wizard opens, set up your import the way you want it, and click the Advanced
button in the lower left corner of the wizard. click Save As, and either
change the default specification name or leave it, and click OK. usually,
you will complete the import, creating a new table that will match the
specfications you selected in the wizard.

now you have an import specification, and a matching table. use those names
in your macro's TransferText action arguments.

hth

 

[Guest]

Tina,
I hae a similar query to what you responded to, so i thought i'd try your
solution. However i cannot find the "advanced" button in the import
spreadsheet wizard. I'm using Access 2003, i'm wishing to import from an
excel spreadsheet, my main problem is the data types all come accross as text
when some are dates or boolean. The import wizard also doesn't allow me to
change the data type, as the option is 'greyed out'. Ultimately i would like
the the whole import and and data type conersion in a macro. I have got the
import sussed out fine just changing the data type of the fields in the table
has stumped me. In addition to the import i would the like to automate the
creation of a relationship..

any help would be most appreciated

 

[Ken Snell [MVP]]

See this Knowledge Base Article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;837003