entering large amounts of data into table

[the_dude via AccessMonster.com]

Hi,

does anyone know how i can enter a whole load of data from excel into and
access table? i would love to just cut and paste but i can only write into
one field at a time. there must be a way to just create a table and dump a
large amount into it from excel.

thanks for any help.

Olli

 

[Tim Ferguson]

does anyone know how i can enter a whole load of data from excel into
and access table? i would love to just cut and paste but i can only
write into one field at a time. there must be a way to just create a
table and dump a large amount into it from excel.

1 - don't copy, just link. Use Get External Data - Attach table to use
the data from the spreadsheet in situ.

2 - use Get External Data - Import to copy the spreadsheet into a new
table

3 - make an append query to read the data into an existing table (this
gives you much better control over the data types that the stuff gets
converted into.

4 - copy-and-paste should work, although I've never tried it.


Hope that helps


Tim F

 

[fredg]

Hi,

does anyone know how i can enter a whole load of data from excel into and
access table? i would love to just cut and paste but i can only write into
one field at a time. there must be a way to just create a table and dump a
large amount into it from excel.

thanks for any help.

Olli

Sure you can Copy and Paste.

Let's say you have 5 columns of data in Excel, and your existing
Access table contains 5 similar fields.

Select all the spreadsheet data you wish copied and Copy it.
Open the Access table in Datasheet view..
Select the appropriate 5 fields (contiguous) in the new record row.
Click Paste.

If this is a seldom done thing, this method should work fine.

If this is done often, import the data, as suggested by Tim.

 

[George Nicholson]

Copy & paste does work, under the right circumstances.
- Copy the data In Excel
- In the Access Table, datasheet view: Select the *entire* row/new
record, not just a field (making sure columns are in the same order as the
data you copied...)
- Paste

 

[Klatuu]

Cut and Paste in Access is technically possible, but it is a mortal sin