Change Field Data Type?

  • Thread starter Thread starter Chertsey
  • Start date Start date
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?
 
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
 
Back
Top