Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Import External Data incomplete

I wrote a SQL script to retrieve data from an MSSQLServer
database onto an Excel sheet using MSQuery. It retrieves
the data completely in MSQuery but when it transfers it
to the Excel worksheet, the data in the columns are
incomplete, like the first parts of names, first parts of
numbers, etc... The Operating System is Windows XP
Professional and Excel 2002 SP2. The SQL query works on
EXCEL 97 and 2000. Can anyone please give me a solution
for this problem? Thank You.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import External Data Bongard Excel Discussion (Misc queries) 3 January 8th 10 06:59 PM
External data import B Cut Excel Discussion (Misc queries) 0 October 16th 09 07:11 PM
Import External Data Willow Excel Discussion (Misc queries) 0 June 8th 07 12:27 PM
Import External Data RFJ Excel Discussion (Misc queries) 1 August 28th 06 12:16 AM
Access import query list incomplete Cydney Excel Worksheet Functions 0 January 30th 06 09:29 PM


All times are GMT +1. The time now is 03:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"