Export from Access/SQL Server

J

JIM

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data From Excel to SQL 2
Problem with Linked SQL Server Table 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Default local file location - folder redirection slowness 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Converting isse with Export in Outlook 0
Unrecognized database format 'S:\xxx.accdb' (Microsoft Jet Database Engine) 0

Top