| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel error while trying to import data from an Access database - MSQRY32.exe has generated errors | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| Lookup Access data in Excel | Excel Worksheet Functions | |||
| How do I paste a mulitpage excel spreadsheet in Word so that is p. | Excel Worksheet Functions | |||
Threaded Mode
