I have an Excel spreasheet that I import to Excel via Macro in Access. The
data type that gets imported from Excel from a column "Age" (which is numeric
data), gets changed to "Text" instead of seeing it as numeric. Is there a
way through my import Macro or VB to check its type, then change this type to
numeric?

Thanks

Here's another approach that may help you circumvent the problem you're
seeing...

Create a "temp" table into which you'll import your Excel data ... and make
all the fields of type "text".

Import from Excel into that table.

Create queries that "convert" data from the temp table into the proper data
types, and appends (or updates) records in your more permanent Access
tables.

I mention a distinction between "temp" and "permanent" Access tables because
raw Excel data is rarely well normalized. If you want to get good use of
Access' relationally-oriented features and functions, you need to have a
well-normalized table structure.

Regards

Jeff Boyce
Microsoft Office/Access MVP



"Racer49" <(E-Mail Removed)> wrote in message
news:7E6BE907-CF96-4B67-BC5A-(E-Mail Removed)...
>I have an Excel spreasheet that I import to Excel via Macro in Access. The
> data type that gets imported from Excel from a column "Age" (which is
> numeric
> data), gets changed to "Text" instead of seeing it as numeric. Is there a
> way through my import Macro or VB to check its type, then change this type
> to
> numeric?
>
> Thanks

That will work! I had not thought of the interim step of having my table be
permanent, then import from the "temp" file via query.. Thanks for this great
tip!

"Jeff Boyce" wrote:

> Here's another approach that may help you circumvent the problem you're
> seeing...
>
> Create a "temp" table into which you'll import your Excel data ... and make
> all the fields of type "text".
>
> Import from Excel into that table.
>
> Create queries that "convert" data from the temp table into the proper data
> types, and appends (or updates) records in your more permanent Access
> tables.
>
> I mention a distinction between "temp" and "permanent" Access tables because
> raw Excel data is rarely well normalized. If you want to get good use of
> Access' relationally-oriented features and functions, you need to have a
> well-normalized table structure.
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
>
> "Racer49" <(E-Mail Removed)> wrote in message
> news:7E6BE907-CF96-4B67-BC5A-(E-Mail Removed)...
> >I have an Excel spreasheet that I import to Excel via Macro in Access. The
> > data type that gets imported from Excel from a column "Age" (which is
> > numeric
> > data), gets changed to "Text" instead of seeing it as numeric. Is there a
> > way through my import Macro or VB to check its type, then change this type
> > to
> > numeric?
> >
> > Thanks
>
>
>