| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Export from Access/SQL Server
I am having a problem exporting a linked SQL server file from Access 2003 to
Excel. The file is about 2,000 records with several columns. The problem is that when the file is imported into excel some of the records are not coming across with the correct data and when numeric fields are summed the totals are wrong. When I export directly to Excel from the SQL server using DTS, I don't have this problem. Has anyone else had this problem? Anyone have ideas of how to fix it? I need to be able to allow the users to create queries in access and export the data they need, so setting up a DTS as a solution is not really workable. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to best monitor threads on this site | Excel Worksheet Functions | |||
| Excel Hyperlinks on Server mapped to other shares dont work. | Excel Discussion (Misc queries) | |||
| Can't export actual text - Get #### instead | Excel Discussion (Misc queries) | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| SQL Server ODBC Error | Excel Discussion (Misc queries) | |||
Linear Mode
