Import an excel file

[phuongkhanh3045]

I have an excel file worksheet(player info sheet)that the user would input information. I then copy that info into another worksheet(player info) in the data fields that I have defined in Access. I then open up my Access database and do a file-get external data-import. I then select my excel file and the worksheet named "player info". I get the import fine but there is a table that gets created that is called: 'Player Info Sheet$'_ImportErrors. I cannot figure out why. Any help would be appreciated. Thanks.

 

[boblarson]

There is data within your Excel Spreadsheet that isn't importing properly. Perhaps this is due to items such as things that exist in cells like headers that you may be using down further in the spreadsheet and it doesn't match the datatype of the data in that column (for example you may have something in there that says SubTotal and the data above it may be numeric. If you open the table it should tell you which column and row the errors came from and you can investigate in the spreadsheet.

 

[phuongkhanh3045]

Thank you for the quick reply. I have checked and was not able to see anything wrong. I know the data field I defined in access is "text". So I tried to change the whole columm as text and it still does not work. Is there a better way of defining a field in excel so that it will see it as text in access?

 

[boblarson]

You may just have embedded spaces (cells without data but with spaces in them) too. That will cause import errors.

 

[phuongkhanh3045]

Is there a way I can email you the files I am talking about so that you can look at it? In the error table, it said field f19 is my problem. So I then go the the excel file and delete everthing in columm 19 and still I am getting the error table. Thanks.