I am importing data from an Excel file to a New Table. Because it doesn't
allow me to change the Data Type during the import process, I am wondering if
there is any way to programatically change the field data type from "Text" to
"Number" in VBA. I am also curious as to why it doesn't allow me to do so in
the Import Spreadsheet Wizard?

Chertsey

If your data is coming from Excel, there's a really good chance that it (the
data) is not well-normalized. So what, you ask? So Access is optimized for
well-normalized data. Both you and Access will have to work overtime to
overcome 'sheet data.

Consider an alternative approach ... import the raw data from Excel as a
first step. Then use queries to parse the raw data into more permanent
Access tables you've designed to be a well-normalized relational database.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Chertsey" <(E-Mail Removed)> wrote in message
news:7131BB21-3C96-481D-A436-(E-Mail Removed)...
>I am importing data from an Excel file to a New Table. Because it doesn't
> allow me to change the Data Type during the import process, I am wondering
> if
> there is any way to programatically change the field data type from "Text"
> to
> "Number" in VBA. I am also curious as to why it doesn't allow me to do so
> in
> the Import Spreadsheet Wizard?