Import from Excel into Access table changes number format

[AKATemp]

Hello all,

I tried searching and am unable to find a solution to this annoying little problem

I have an excel table called Parameter with a column called "Test" -- The column contains integer numbers only. So all the numbers in the column are like 5,10,15,20 etc

I have an access macro which imports the entire excel table into a access table called dbo_Parameters

I have created an access macro to run "Saved Import" for 'dbo_Parameters"

Here is the funny part.

After uploading, all the data in the column Test is formatted to mm/dd/yyyy. The Field Size is Integer, but the format is view format is converted to a Date!! :banghead:

I do not understand why this is happening. In order to fix this, I have to change the properties of the column to "General Number" and get rid of the date format.

This happens every time I import. So, I suspect that there is something wrong going on during the import. But for the life of me I am unable to understand how to change the import format!

Here is what I have already triple checked:

a) The format of the column in Excel - It is number
b) The import procedure and saved import. I am unable to change the format of the import during upload. I make sure that the import format column is Integer

Thank you for your time!

Regards,

 

[CJ_London]

Parameters and Parameter are reserved words. Using them can have unexpected results so recommend you change the name in your excel spreadsheet and see if this resolves the problem.

See this link for a list of reserved words

http://office.microsoft.com/en-gb/a...7-reserved-words-and-symbols-HA010030643.aspx