![]() |
Need help converting MS Access to Excel
Hi,
I'm using MS Access 97, I'm pretty sure (am not in front of that computer) and Excel of the same vintage. I would like to convert my MS Access DB to an Excel spreadsheet, but didn't see any obvious way to do it (didn't see anything likely in the Export command), and when I tried just copying from Access (not sure which view I was in, but looking at a grid full of data) and pasting into Excel, the formatting was messed up (that is, what was in one field in Access didn't end up in one field in Excel; IIRC, it took everything from the Access DB and put it into one Excel field). If anyone has ideas, please let me know. If all else fails, I will type the whole thing into Excel, but would like to avoid that. :-) Thanks. |
Need help converting MS Access to Excel
With Excel open to a new workbook.
Try DataImport External DataNew DataBase Query. Find your Access DB and follow your nose. Gord Dibben MS Excel MVP On 26 Mar 2007 14:22:16 -0700, "mustaine" wrote: Hi, I'm using MS Access 97, I'm pretty sure (am not in front of that computer) and Excel of the same vintage. I would like to convert my MS Access DB to an Excel spreadsheet, but didn't see any obvious way to do it (didn't see anything likely in the Export command), and when I tried just copying from Access (not sure which view I was in, but looking at a grid full of data) and pasting into Excel, the formatting was messed up (that is, what was in one field in Access didn't end up in one field in Excel; IIRC, it took everything from the Access DB and put it into one Excel field). If anyone has ideas, please let me know. If all else fails, I will type the whole thing into Excel, but would like to avoid that. :-) Thanks. |
Need help converting MS Access to Excel
I'll give 'er a whirl. Thanks very much.
On Mar 26, 3:18 pm, Gord Dibben <gorddibbATshawDOTca wrote: With Excel open to a new workbook. Try DataImport External DataNew DataBase Query. Find your Access DB and follow your nose. Gord Dibben MS Excel MVP On 26 Mar 2007 14:22:16 -0700, "mustaine" wrote: Hi, I'm using MS Access 97, I'm pretty sure (am not in front of that computer) and Excel of the same vintage. I would like to convert my MS Access DB to an Excel spreadsheet, but didn't see any obvious way to do it (didn't see anything likely in the Export command), and when I tried just copying from Access (not sure which view I was in, but looking at a grid full of data) and pasting into Excel, the formatting was messed up (that is, what was in one field in Access didn't end up in one field in Excel; IIRC, it took everything from the Access DB and put it into one Excel field). If anyone has ideas, please let me know. If all else fails, I will type the whole thing into Excel, but would like to avoid that. :-) Thanks. |
Need help converting MS Access to Excel
With the table open, do a File / Export, twards the bottom where it says Save
as Type, when you click the little triangle on the right side of the field, what options show up? You are trying to export a table, not a report, right? "mustaine" wrote: Hi, I'm using MS Access 97, I'm pretty sure (am not in front of that computer) and Excel of the same vintage. I would like to convert my MS Access DB to an Excel spreadsheet, but didn't see any obvious way to do it (didn't see anything likely in the Export command), and when I tried just copying from Access (not sure which view I was in, but looking at a grid full of data) and pasting into Excel, the formatting was messed up (that is, what was in one field in Access didn't end up in one field in Excel; IIRC, it took everything from the Access DB and put it into one Excel field). If anyone has ideas, please let me know. If all else fails, I will type the whole thing into Excel, but would like to avoid that. :-) Thanks. |
All times are GMT +1. The time now is 12:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com