import Excel data - difficulty

craigexcel

Active Member
Joined
Jun 28, 2006
Messages
277
I have attempted a number of combinations of copying / pasting / appending Excel data into a table in Access. I've tried copying just the specific Excel range, the entire rows with the data, and the entire worksheet. When trying to get it into Access, I've tried Paste, Paste Special (as text), Paste Append. The 2 error messages I have been receiving are (1) The value you entered isn't valid for this field., and (2) The text is too long to be edited.

The source data in Excel is in exactly the same format (by field), and each record is of exactly the same type. (A weekly file is imported.)

Any suggestions as to an alternate method for getting the data into Access from Excel, or, suggestions for where to look to resolve the error messages I've received?
Thanks.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
Have you tried....?

Opening Access
Click on File/Get External Data/Import?
 

craigexcel

Active Member
Joined
Jun 28, 2006
Messages
277
While this worked (i.e. the data was imported into a new table), what's the key (mechanism) to pasting (appending) this data into the existing table that has all my previous data in it?
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,300
Office Version
  1. 365
Platform
  1. Windows
Can't you just select the existing table from the dropdown on step 3 (?) of the import wizard?
 

MyBoo

Board Regular
Joined
Aug 9, 2006
Messages
217
After importing the Excel spreadsheet, you create a new query, based on that new table and after selecting the fields you want (testing for correct results), you turn your query into an Append Query and point to the table you want to add the new data to.
 

Forum statistics

Threads
1,136,427
Messages
5,675,777
Members
419,585
Latest member
popsin

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