Khurram has attended:
Access Intermediate course
How to transfer sheets from access to excel
How can i in its simplest form transfer a table into excell?
RE: How to transfer sheets from access to excel
Hello Khurram,
Hope you enjoyed your Muicrosoft Access Intermediate training last week.
Yes, this question is often asked on our courses.
In the Database window, click the name of the datasheet, form, or report you want to save and load into Microsoft Excel. To save a selection of a datasheet, open the datasheet, and then select the portion of the datasheet before continuing.
On the Tools menu, point to Office Links,
then click Analyze It with Microsoft Excel.
TIPS:
-Because Excel only supports 256 columns and 65,536 rows, data in columns IW through ZZZ and rows 65,537 through 262,144 are not exported from the spreadsheet. You can, however, copy this data to more than one Excel worksheet.
-When you export data from a spreadsheet to Excel, only the values and formulas are exported. Links that connect to other data on the Web page or to other Web pages are not retained in Excel.
-When you export some spreadsheet number formats, the data in Excel is displayed with a custom number format. For example, the Yes/no, True/false, and On/off spreadsheet formats are displayed with custom number formats in Excel.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Access or Microsoft Excel question?
Have a great day.
Regards,
Richard
Microsoft Office Specialist Trainer
