Results 1 to 2 of 2
2001-01-23, 15:54 #1WorkerGuest
Importing Access Report into Excel
Anyone know how to import an access report (or a csv or text file) into Excel, and keep the same format? I am somewhat program literate - I can do simple macros in VBA, but this has me stumped! I can import a table or query with no problems, but the report is giving me problems. I would greatly appreciate any help. Thanks!
2001-01-23, 23:49 #2
- Join Date
- Dec 2000
- New Zealand
- Thanked 0 Times in 0 Posts
Re: Importing Access Report into Excel.
Try doing it the other way round. Exporting from Access to Excel is easier. When you are previewing your report there should be an Excel or Word button in the toolbar. By clicking the excel button a spreadsheet version of the report will be created.