Paste Access data into Excel spreadsheet
I was recently upgraded from Office97 to Office2002 (XP, I believe). In the
past, if I copy and pasted Access data into an Excel spreadsheet, Excel was able to determine if the individual fields were text or number or date. With the upgrade, all fields are set as text when they are copied into Excel. This presents a problem with formulas I have set-up in Excel that are looking to calculate number fields. I have even tried to change the fields to number fields, but this doesn't work and is a bit tedious, too Does anyone know how I can get the process to work like it did with Office97? Thanks! |
I'm not much of an Access user but I just opened the Orders table in the
Northwind database that comes with Office in Access 2003 and copy/pasted it into Excel 2002 (and 2003) and all fields seemed to come in as they should. Dates stayed dates, numbers numbers... -- Jim "JDM" wrote in message ... |I was recently upgraded from Office97 to Office2002 (XP, I believe). In the | past, if I copy and pasted Access data into an Excel spreadsheet, Excel was | able to determine if the individual fields were text or number or date. With | the upgrade, all fields are set as text when they are copied into Excel. | This presents a problem with formulas I have set-up in Excel that are looking | to calculate number fields. I have even tried to change the fields to number | fields, but this doesn't work and is a bit tedious, too Does anyone know how | I can get the process to work like it did with Office97? | | Thanks! |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com