It is currently Mon Dec 07, 2009 2:12 pm



Welcome
Welcome to WorldPT Live

You are currently viewing our site as a guest, which gives you access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, join our community today!


Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Analyze data in Excel or Open Office Calc
PostPosted: Tue Oct 14, 2008 1:59 pm 
Offline
Site Admin

Joined: Sat Aug 02, 2008 2:37 pm
Posts: 30
On the Reports tab on the left side you will see a drop down menu for tables. You may open any of the table and select all the records and hit Control + C. You can open Excel or another spreadsheet program and paste the records into a new sheet. From the spreadsheet program you can slice and dice you data anyway you choose. It is also possible to create a link between the spreadsheet file and the schedule_be600.mdb file. This is done best using Excel 2007. Google linking Access 2007 database to Excel for detailed assistance. Make a backup of Schedule_be600.mdb before dong any linking operation.


Report this post
Top
 Profile Send private message  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron