Importing Excel issues

[Sully38]

My assignment is I am importing an excel spreadsheet that will drive some currency breakout through querried values. The Excel fields are in a general number valued and to the 15 decimal place. I have to rework this data into a percentage and keep it at 15 decimal places. My question are

1. When I import the field shouldn't Access give me the option to either not change the value I am importing and/or allow me to determine what data type I would like to use. Everytime I go through the import process the data field is blacked out and Access is bringing the value in as a Double. Is there something I am missing?

2. After I read the data into a table I have tried to change the data type to percent it changes the record to(example 70.00 to 7000.00%) any clues as to why?

I know these are a lot of questions and it is the weekend..But any help is appreciated.

This database

 

[Joe4]

1. When I import the field shouldn't Access give me the option to either not change the value I am importing and/or allow me to determine what data type I would like to use. Everytime I go through the import process the data field is blacked out and Access is bringing the value in as a Double. Is there something I am missing?

When importing from an Excel file, Access does not give you the ability to change the data format upon input. It takes it from the Excel file. If you want to change it upon importing it into Access, save your Excel file to a text file and then import the text file.

2. After I read the data into a table I have tried to change the data type to percent it changes the record to(example 70.00 to 7000.00%) any clues as to why?

A percent translates into a decimal (it is a mathematical law, not an Excel or Access issue). For example, 75% = .75. So if you wanted 70 to translate into 70%, you would need to divide by 100 first, so you start out with .70 which would then translate into 70%.