Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Uploading Spreadsheets and Worksheets into Access Databases
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Uploading Spreadsheets and Worksheets into Access Databases
Resolved · Low Priority · Version Standard
Reply Mon 12 Feb 2007, 15:28Delegate 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
For upcoming training course dates see: Pricing & availability
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).
|