Paste Record from Excel

[Guest]

Hi,

I have a table in Access with 3 fields, SysRef, Name, Amount.
Everyday I would like to paste several records into this table from an excel
spreadsheet, like below, but copying the data in Excel and simply pasting it
into the table in datasheet view doesn't work, I get a "Field too small for
data", I assume its trying to paste everything into one cell.
I don't really want to use VBA, or Transferspreadsheet, because someone else
will be doing the updating.


SysRef Name Amount
159 James 589
175 Nicola 786 I simply want to copy these
records into the
586 Voila 128 Access table. I add records
like this to the
table on a daily basis.

How can i copy and paste the records from Excel straight into an Acess Table?
All help is appreciated.

 

[fredg]

Hi,

I have a table in Access with 3 fields, SysRef, Name, Amount.
Everyday I would like to paste several records into this table from an excel
spreadsheet, like below, but copying the data in Excel and simply pasting it
into the table in datasheet view doesn't work, I get a "Field too small for
data", I assume its trying to paste everything into one cell.
I don't really want to use VBA, or Transferspreadsheet, because someone else
will be doing the updating.

SysRef Name Amount
159 James 589
175 Nicola 786 I simply want to copy these
records into the
586 Voila 128 Access table. I add records
like this to the
table on a daily basis.

How can i copy and paste the records from Excel straight into an Acess Table?
All help is appreciated.

If you wish to manually copy the records from Excel to an Access
table, first select the contiguous data in Excel. Click Copy.

Then open the Access Table in datasheet view.

If you wish to replace existing data, select the rows you wish to
replace. Click Paste.

If you wish to append the new data to the existing table, select the 3
fields in new record position.
While the fields are highlighted, click Paste.

 

[Ron2006]

The key is not to be in ONE particular field. Either select the entire
new record or at least the same number of fields as you have copied.