Import Data

thesuggs76

Board Regular
Joined
Nov 15, 2006
Messages
247
Hi All
I'm importing data from an Excel spreadsheet into an Access table. However when i do it I get an Import Error table, as there is an error with a few of the columns. This does not happen all the time however there are 3 columns which have both numbers and letters, but with other columns it does work. I've check the format of these and I've changed the cells that are affected but no joy.
Any suggestions???
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,467
Office Version
  1. 365
Platform
  1. Windows
You will have more control over the input if you convert the Excel file to a text (.csv) file and then import it. When you do this, you can set the type of field you wish to have for each Excel column. What is happening now, is that because you have a mixed format in your Excel column, Access is guessing as to the type of data and for the cells that don't meet that format type, it is kicking out an error.

During your import of the .csv file, click on the advanced control and select how you want the data imported.

Alan
 

Forum statistics

Threads
1,141,218
Messages
5,705,080
Members
421,377
Latest member
FerdiFuchs

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top