Pasting data from a spreadsheet to database

[Paris1980]

Hi there,

I have a spreadsheet which has a large amount of data. It is organnised by database structure. I'm aware of primary keys etc but what I want to avoid is creating each field as new.

For example I would like to copy the feilds from excel and paste them to create feilds in access. I'm aware that I would have to manually input any special parameters. This would save me a couple of hours.

Any help would be appreciated.

Thanks