Change Field Data Type?

C

Chertsey

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?
 
J

Jeff Boyce

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't specify data type during import - Access 2003 3
how to change data type while importing 1
Importing from Excel to Access 1
Importing an Excel File 1
Different field formats 2
Can I change the data type when importing an Excel list to Access 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Type Conversion Failure importing number as text 1

Top