microsoft access courses - Uploading Spreadsheets and Worksheets into Access Databases

Resolved · Low Priority · Version Standard

Uploading Spreadsheets and Worksheets into Access Databases

Clare has attended:
Access Introduction course

by - delegate Clare [6 posts] (2007 Feb 12 Mon, 15:28) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
2003	2009 Jan 6 Tue	Southwark	5	book now	£198	£215
Full Schedule: See all 51 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Uploading Spreadsheets and Worksheets into Access Databases

by - trainer Carlos gold contributer [479 posts] (2007 Feb 20 Tue, 09:28) Reply

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).