Changing Data Type Automatically when importing into Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I seem to recall that there is a way to have Access automatically convert
numeric data to text when importing into an Access table from an excel file.
Can a macro be written for this? Any help or suggestions would be
appreciated.

Thanks!
 
A multi-step process...

First, link to or import the "raw" Excel data.

Next, use a series of queries to parse the (probably flat-file) data from
the raw Excel data structure into your well-normalized (you HAVE normalized
your data, right?!) tables.

Now, if you want this to be automated, you could use a macro to run each/all
of those queries, or you could write a VBA procedure that runs each/all of
those queries.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top