Copy and paste from Excel to access.

[howamidifferent]

Is it possible to copy and paste a range from Excel 2003 to Access 2003
where the format of the excel sheet matches the format of the datagrid?
Access responds with "the text is to long to be edited".

If not, is there any other way to copy in ranges of data to update or append
to an existing access table? I might want to update or I may want to append.
I though if I selected the correct record and pasted it would flow down and
change the values ot would have pasted over but it doesnt work.

 

[Guest]

Look in VB Help for the TransferSpreadsheet method. It may be what you need.

 

[fredg]

Is it possible to copy and paste a range from Excel 2003 to Access 2003
where the format of the excel sheet matches the format of the datagrid?
Access responds with "the text is to long to be edited".

If not, is there any other way to copy in ranges of data to update or append
to an existing access table? I might want to update or I may want to append.
I though if I selected the correct record and pasted it would flow down and
change the values ot would have pasted over but it doesnt work.

You're trying to paste into one field.
You have to select all the fields you wish to paste into.

In Excel, select the contiguous rage of cells.
Lets say 3 columns by 4 rows.
Copy.


Open the Access table.
To replace existing data:
Select the 3 columns and 4 rows in the table (hold the shift key down)
Paste.

To Append the new data, select the 3 columns in the new record row
instead.
Paste

Also, you can import a range of cells using the TransferSpreadsheet
method.
See VBA help.