microsoft access courses - Uploading Spreadsheets and Worksheets into Access Databases

Resolved · Low Priority · Version Standard

Mon 12 Feb 2007, 15:28 Delegate Clare said...

Clare has attended:
Access Introduction course

Uploading Spreadsheets and Worksheets into Access Databases

Hi

I could do with some advice on uplading information form spreadsheets and various worksheets within a spreadsheet into a database.

I am aware that it is possible to upload a single worksheet into an access database, my question is, is it a problem to ask the database to upload information from two separate worksheets within a spreadsheet?

Is is better to keep it as two spreadsheets?

Or can you specify certain fields off each worksheet?

What happens if someone changes a heading of a column in a worksheet, will it reject the upload? Or what if someone changed the column order?

Any advice on this would be great

Thanks

Tue 20 Feb 2007, 09:28 Trainer Carlos said...

RE: Uploading Spreadsheets and Worksheets into Access Databases

Hi Clare

If you want to upload more than one worksheet from an excel workbook you have two options:

1. Import each worksheet separately and then use an Upend Query to unite the data.

2. If this is a recurring job or you need some fields from one sheet and the rest from another, you will need to use Macros(VBA code).

Training courses