Cell Format/Data Type: Importing Excel to Access

[Dave32]

All,

I want to import an Excel worksheet into Access. I will use the Import wizard in Access.

In Excel, I have some cells formated as "General" the contain text. However, in Access the data type is "Text" as I cannot choose "General" is that going to cause problems?

Do I need to change the format of the Excel Cells so there are "Text".

Thanks,

Dave32

 

[neileg]

You can't, in general, set a datatype within Excel. The data is the data. In Access, the reverse is true and you have a single datatype for each column (field) in your table. If the data is text in Excel, then use a text datatype in Access.

 

[Dave32]

Neil,

Thanks for your help. Another question, do the number of fields in the Excel sheet need to be exactly the same as in Access?

I am not importing data for all the fields in Access?

Regards,

David

 

[neileg]

No you can skip columns.

 

[apr pillai]

Data Type in Excel

If you have advance planing for your Database in Excel you can control Cell Data Types, like accept Whole Number only, Decimal, List, Date, Time etc. and can set Data entry Limitations like accept Number between 1 and 100 only or Text length upto 40 characters and so on.

Check the Option Data - - > Validation - -> Setting. After setting Input Rules and enter data into the Cells you can control data types in excel to a certain extend.

Regards,
a.p.r. pillai
www.msaccesstips.com