Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

123183 - 2007: How to export data to a text file with comma and quote delimiter in Excel

Knowledge Base Articles - 2003

066033 - 2003: Hexadecimal Values Changed When Imported from .CSV File

Knowledge Base Articles - 2002

292469 - 2002: 'Import Text File' Dialog Box Is Displayed When You Refresh External Data

291199 - 2002: 'Invalid Use of New Keyword' Error Using ADODB Object Library

284868 - 2002: 'Invalid XML Declaration' Error Message When You Import Data from a Web Source

291060 - 2002: 'Problems Came Up in the Following Areas During Load...' Error Exporting Spreadsheet or PivotTable to Excel

282133 - 2002: Columns Are Removed and Other Columns Are Moved to the Left When You Refresh Query Table

814020 - 2002: Excel Data Changes Font Format After You Edit the Excel Data in Word

277600 - 2002: Imported Data Source Password Is Not Saved with File over ODBC Connection

120596 - 2002: Importing text files larger than 65536 rows

291296 - 2002: Procedure to export a text file with both comma and quote delimiters in Excel

294973 - 2002: Script Error When You Export to Excel from Internet Explorer

214275 - 2002: Using 16-Bit and 32-Bit ODBC Drivers

Knowledge Base Articles - 2000

111046 - 2000: 'Cannot Define Primary' in Paradox Table

121525 - 2000: 'Cant Access Table...' Using Shared Paradox Database

284210 - 2000: 'Incomplete Calculation' Error When You Open File Linked to Exported Access Table

115090 - 2000: 'Out of Memory' Error with More Than 4000 Tables

210824 - 2000: 'Problems Came Up in the Following Areas During Load...' Error Exporting Spreadsheet or PivotTable to Excel

115340 - 2000: 'Query Can Have Only One Outer Join'

121523 - 2000: .DBF Table Created in MSQUERY Not Recognized in dBASE III/III+

108190 - 2000: Cannot Create Index with Text ODBC Data Source

113169 - 2000: Cannot Create Paradox Index

108891 - 2000: Cant Add Index to Read-Only Table

121597 - 2000: Cant Escape Query Using dBASE Data Source

113317 - 2000: Case Sensitive Table Names Not Recognized

107745 - 2000: Client Not Updated with Multiple Instances of Excel

258871 - 2000: Data Truncated When You Get External Sybase Data

115430 - 2000: Data from Query Not Returned to the Worksheet

114954 - 2000: Dates Displayed as Serial in Second Link to MSQuery Data

121865 - 2000: Default Value for Access Table Ignored

112854 - 2000: Err Msgs When Dynamic MSQuery/Microsoft Excel Links Activated

231078 - 2000: Error Message When You Refresh External Data Query or Connect to External Database Source

211510 - 2000: Error When Dragging Embedded Chart into Microsoft Word

244606 - 2000: Error When You Use Excel Query Table to Import Access Database Table as DAO Recordset

121598 - 2000: ErrorText Item Not Returned Using DDE

212155 - 2000: Errors Appear When Using an ODBC Text Data Source (DSN)

213960 - 2000: Excel Cannot Update Links to a Microsoft Access Query

121551 - 2000: Field Instead of Column Name in MSQUERY Returned to Excel

253300 - 2000: How to Avoid Saving Password in Text File When You Get External Data

119700 - 2000: How to Undelete Records and Pack dBASE Files

213187 - 2000: How to Use the Query BeforeRefresh and AfterRefresh Events

272729 - 2000: How to import data with more than 256 fields or columns into Excel

124231 - 2000: Incorrect Display of Extended Character in Field Name

114286 - 2000: Invalid Column Number Adding Fields from Table

215155 - 2000: Linked Excel Sheet Appears to Make Computer Stop Responding

213816 - 2000: Macro to Import a Text File into an Existing Worksheet

213316 - 2000: Macro to Link a Range of Cells in Word

108061 - 2000: May Not Receive Error Message with Invalid Query

213605 - 2000: Named Argument Not Found Error with DAO

114991 - 2000: No MSYSMacros in System Table List for MS Access Database

108893 - 2000: No Result Set From Tables Joined with Outer Then Inner Join

121596 - 2000: Not All Unique Indexes Appear Bold

121550 - 2000: ORA-00911 Error Adding Record to Oracle Table

116010 - 2000: Opening Query Failed Accessing Oracle

183050 - 2000: Queries No Longer Work After Upgrading Oracle ODBC Driver

211931 - 2000: Query Is Not Executed in the Background

211624 - 2000: Query Is Not Updated When File Is Opened

114150 - 2000: Query to Find Unmatched Records Between Two Files

108827 - 2000: SQL Data Source Connection Limit

115792 - 2000: Saving or Opening a Query Also Executes the Query

211926 - 2000: Specify Dynamic Web Query Parameters in Excel 2000

179841 - 2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel

121526 - 2000: dBASE Data Source Uses FoxPro Index File

110601 - 2000: dBASE Files and Field Limits

Knowledge Base Articles - 1997

185017 - 1997: 'File Not Found' Error Activating Excel Object

175227 - 1997: 'Invalid Page Fault' Pasting Linked Text from MS Word

190106 - 1997: 'Invalid rows to scan' Error Creating Excel Data Source

157062 - 1997: Cannot Clear 'Sort by' List in Query Wizard

192405 - 1997: Copy and Paste from Access to Excel May Generate Errors

134261 - 1997: Data Map Colors Lost When File Exported to Macintosh

168702 - 1997: Data Not Returned from Query Using ORACLE Data Source

170739 - 1997: Date Format Is Not Retained in Parameters Dialog Box

169765 - 1997: Error Activating Worksheet That Contains Controls

129793 - 1997: Excel Displays Only First Column in Embedded Worksheet

122890 - 1997: Exporting Lotus 1-2-3 Linked Files to Excel

165779 - 1997: External Data Range Property Not Saved with Workbook

165499 - 1997: How to Import Web Page Tables into Microsoft Excel

182735 - 1997: How to Use the Query Before and AfterRefresh Events

103274 - 1997: Importing Word Tables Into Microsoft Excel

096146 - 1997: Lotus WK1 File Loses Formatting when Opened in Excel

123434 - 1997: Multiple Entries in Lotus Notes Import/Export List

163895 - 1997: Problems Importing Files from Quattro Pro 7.0

247801 - 1997: Programmatically Exporting Text File Truncates Dates

161759 - 1997: Query Is Not Executed in the Background

184388 - 1997: Query Is Not Updated When File Is Opened

171578 - 1997: Query Wizard May Not Appear When Editing Query

137427 - 1997: Question Marks Appear After Deactivating Worksheet Object

283861 - 1997: SR-2: 'Incomplete Calculation' Error When You Open File Linked to Exported Access Table

111397 - 1997: Some Special Characters Are Changed in Imported Files

118374 - 1997: Supported Graphic File Formats for Import