Stuart

You can select the data in Excel and Copy. Open Access if
you have already creaded the database use
Edit, Paste-Append. The data will be added to existing
data. Access will produce an error message and a table of
errors that you should be able to delete (but check first).

If the Table has not been created then create a new table
in TAble view and Paste Append the data again. You can
alter the Field Names Later in design View.

Refards
Peter
-----Original Message-----
Hi

I need to export data in a worksheet to an access DB
table, however due to the amount of data, exporting row
by
row is very long.
Is there a way where i can export the entire sheet in one
go with columns representing fields in the table?

Any help would be greatly appreciated.

CHeers
STuart
.