Report Problem

  • Thread starter Thread starter Carl via AccessMonster.com
  • Start date Start date
C

Carl via AccessMonster.com

I have an issues with my Microsft Access Database. It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers. We have 11 computers in our
office. Each computer has Microsoft Access 97, 200, XP, and 2004 on each
computer. We recently compacted all of our databases into one database.

My question is, is there a way to excract our information from the new
databases back into an excel spreadsheets? We have Microsoft Excel 97, 200,
XP, and 2004 on each computer. I wanna bring the data from Microosft Access
databases into the spreadsheet. I also, want to scroll up the report in the
Access Database Program.

Thank you,
Tony
 
Carl via AccessMonster.com said:
I have an issues with my Microsft Access Database. It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers. We have 11 computers in our
office. Each computer has Microsoft Access 97, 200, XP, and 2004 on each
computer. We recently compacted all of our databases into one database.

My question is, is there a way to excract our information from the new
databases back into an excel spreadsheets? We have Microsoft Excel 97, 200,
XP, and 2004 on each computer. I wanna bring the data from Microosft Access
databases into the spreadsheet. I also, want to scroll up the report in the
Access Database Program.
Click to expand...

You can right-click a table, click Export, and select an Excel file format
to extract the table to Excel. If you want to do a more automated approach
that loops through tables and does this automatically, you'd need to use some
code. Put this code in a coomand button's On Click event:
Dim tbl As TableDef
For Each tbl In CurrentDb.TableDefs
If Left$(tbl.Name, 4) <> "msys" Then
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
tbl.Name, "c:\" & tbl.Name & ".xls"
End If
Next

I'm not sure what you mean by "I also, want to scroll up the report in the
Access Database Program."

Barry
 
Back
Top