Re: Copy and paste from Excel to access.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Wed, 10 May 2006 13:32:40 +0100, howamidifferent wrote:

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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.

Relevant Pages

  • Copy and paste from Excel to access.
    ... where the format of the excel sheet matches the format of the datagrid? ... I might want to update or I may want to append. ... change the values ot would have pasted over but it doesnt work. ...
    (microsoft.public.access.gettingstarted)
  • Copy/Paste from Excel To Access
    ... where the format of the excel sheet matches the format of the datagrid? ... I might want to update or I may want to append. ... change the values ot would have pasted over but it doesnt work. ...
    (microsoft.public.access.conversion)
  • RE: SaveWorkbookAsToday()
    ... Create a string variables for the day and convert your date to the format you ... Then append or concatenate the string date where necessary in the file name. ... Dim DateFormat As String ...
    (microsoft.public.excel.programming)
  • Re: Write position
    ... Formatted direct-access file: nearly as complicated as except that the record-length is not generally o/s-dependent, and you can use a formatted write, but you need to get the format correct to fill the record (including the newline sequence). ... As for direct-access you need to convert the numbers to text yourself with an internal file write, and append the newline sequences yourself, but a minor advantage is that you don't have to worry about record lengths at all. ...
    (comp.lang.fortran)
  • Re: Where were you 10 years ago today
    ... called "ddate" which produces output of the format: ... My preference is to append the file's modification date, ... where $F contains filename, to create a suffix. ... echo $) ...
    (rec.crafts.metalworking)