Problem importing excel file

[GeneHunt59]

Hi,

I created a database and imported an excel file. However, one of the columns did not download properly. Despite setting the column up as a text field Access seems to think it is a number field and therefore fails to include hundreds of alpha-numeric entries in the column, the number-only entries are fine. I have tried re-naming the spreadsheet, even creating the database totally from scratch, but I still get the same problem.

Many thanks in advance for any assistance
Alan

 

[Mike375]

Try doing TransferSpreadsheet and to a table you have in Access.

I am not sure but if you make the row in Excel have alpha characters Access will create text field in new table.

 

[mihabaki]

Hi,

I created a database and imported an excel file. However, one of the columns did not download properly. Despite setting the column up as a text field Access seems to think it is a number field and therefore fails to include hundreds of alpha-numeric entries in the column, the number-only entries are fine. I have tried re-naming the spreadsheet, even creating the database totally from scratch, but I still get the same problem.

Many thanks in advance for any assistance
Alan

Empty the imported table (it has to be "local" table in Access) and change the type of the ("problematic") field to text.

Then select all the rows in your Excel source table and copy/paste to the table in Access.

M