importing excel into access

[SoxPats83]

i have imported my excel documents into access hundreds of times in the past with little to no problems. i have run into a scenario today where i try to import an excel spreadsheet with specific collums that have both number and text values. when importing into access i am told that the import was succesfull but certain fields could not be imported. and it turns out the fields that could not be imported were the text fields. in the design view the data type is set to text. i am kinda confused by this...

 

[SoxPats83]

sorry, i figured it out. i failed to format the cells properly within excel. thanks to anyone who viewed...

 

[MSAccessRookie]

i have imported my excel documents into access hundreds of times in the past with little to no problems. i have run into a scenario today where i try to import an excel spreadsheet with specific collums that have both number and text values. when importing into access i am told that the import was succesfull but certain fields could not be imported. and it turns out the fields that could not be imported were the text fields. in the design view the data type is set to text. i am kinda confused by this...

I am not positive that this is your issue, but I have encountered instances in the past where a similar problem occurred. What I discovered was that when importing datya that has any TEXT columns that could be interpreted as multiple data types (Numeric / Text or perhaps Date / Text), Access will create the column based on the FIRST instance of data that it encounters.

My solution has been to create an Access Table in advance that has all of the desired Column Types.