Changing Data Type Automatically when importing into Access

[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!

 

[Jeff Boyce]

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