Karen- From Access you can file->export and it will export a table or query depending on what you need. You can export in .xls format. -Anthony -----Original Message----- From: Karen Willingham [mailto:kwillingham@xxxxxxxxxxxxxxxxxxxxxxxxx] Sent: Tuesday, January 14, 2003 1:55 PM To: 'mso@xxxxxxxxxxxxx' Subject: [mso] Re: Excel and Access Import Data is grayed out. I even installed. It is stilled tryout. ---------------------------------------------------------------------------- --- In Excel, go to the Data menu and choose Import External Data..then choose Import Data...browse to your Access Database and double click on it...then choose the table that holds the data Linda Publisher ~ ABC ~ All 'Bout Computers --------------------------------------------------------- I need to get some numbers from Access Database and have it in this excel format. How do I do that? I know I did it 2 years ago but now I forgot how and where to start. Thanks Karen ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************