import excel files - changing data types

[Darren]

Hi,

I am trying to automate a process to import excel files into access. I can
get the data I want into the temporary table easily enough - my problem is
that I need two of the fields to be text data types not number (as I need to
run an append query to add leading zeros). Is there an easy way of doing this
(other than actually going into the table and changing the attributes)?

Any ideas would be greatly apreciated

Darren

 

[John Nurick]

Hi Darren,

If you're importing the Excel data into a temporary table, don't worry
about the field types at this stage. Make the corresponding fields in
the "permanent" table Text fields, and then do the type conversion in
the append query that moves the data from the temporary table, using
calculated fields similar to this
Format([NumericField], "000000")