Access Conversion Resource Center
General information about converting, importing, and exporting files
Working with Text Files
Interoperability with other Microsoft programs
Excel
Word
Works
FoxPro
SQL Server
Visual Basic for Applications
Working with earlier versions of Access
Working with HTML, ASP or IDC files
Interoperability with third-party programs
General Information About Converting, Importing, and Exporting Files
Where can I find the Conversion White Paper for Access 2000?
Where can I find tips for troubleshooting conversion issues for Access 2000?
Why does my converted Access 2.0 report have different margins?
Why are my ActiveX controls not converted?
How do I link or import tables?
Why do time or date values in my query criteria return different results?
What files types for importing, exporting, and linking are supported in Access 2000?
Why do I not see all extensions in the Files of Type List in the Open, Export, Import, or Link dialog box?
Why are references not imported with objects from another database?
What happens to the table filter after I import a table?
When I export a query that contains an expression that results in more than 255 characters, why is the expression truncated?
Why is my expression truncated after I export my query?
How do I optimize Access by using ODBC data sources?
When I try to open a linked table in a shared .MDB file, why do I receive an error message that the file or path isn't valid, or that Access cannot open the file?
Why do I receive the "Could Not Find Installable ISAM" error message?
What time format is supported when I convert files to or from Access?
Can I use the PrtDevMode or PrtMip Property with MDE files?
Why are records missing after I import a table into an Access Data Page?
Why is there no primary key on a copied or imported table in an Access project?
What data types change when I import a table from an Access project into an Access database?
Can I link to a table in an Access Project (*.adp)?
Why are forms based on ADO recordsets read-only?
Does Name AutoCorrect repair imported objects?
Why do I receive the "Cannot update. Database or object is read-only" error message when I try to export an object from Access 2000?
How do I automate importing all files in a specific folder?
Does Access use default values when importing data into an existing Access table?
Can I export a file if its name is more than 60 characters?
Top
Working with Text Files
Why does the resulting table from an import not contain indexes?
If I filter a table on specific time values, the filter doesn't return any records. Why?
How do I export numeric data with quotation marks and commas?
How do I create and save data export specifications?
Why do I receive a Type Conversion error message when I import a fixed-width file with two Date fields that have different formats?
Why are numbers left-aligned after I export an Access 2000 table to a fixed width format?
Why am I receiving an invalid argument error message when I export to text?
Why doesn't Access respond when I click the Advanced button in the Import Text Wizard?
Why do I receive the "Can't update. Database or object is read-only" error message when I import text files?
How do I import a delimited text file that has a field that contains values in a Medium Date format (DDMMMYY)?
Why is text in a report saved in Rich Text Format or MS-DOS Text format wrapped differently from the original report?
Why can't I import data from a fixed-width text file?
How do I export the result of a query to an ASCII text file?
Can I import YYMMDD dates in fixed-width text files?
Why does Microsoft Access interpret each carriage return/line feed as a new record delimiter when I import a fixed-width text file?
Can I export part of a table to a text file?
When I export Date fields to text, why do they include the time?
When I run the Import Text Wizard, I receive error messages, the records are combined into a single continuous record, or my computer stops responding . Why?
Why does the size of the database increase when I import a large text file?
Why do I receive a run-time error when I use the TransferText method to import or export a text file?
How do I export right-aligned or left-aligned fields to a text file?
Why am I not prompted for a parameter value when I output a form to text?
Why doesn't Access create an Import Errors table during a failed import?
Top
Interoperability with other Microsoft Programs
Excel
Why doesn't Access create an Import Errors table during a failed import?
Why do I receive the "Too Many Rows" error message when I use the "Analyze It with MS Excel" feature?
Why is the bold font style replaced by a regular font style when I export a table from Access to Excel?
Why do I receive the "Numeric Field Overflow" error message when I export a table to Excel?
After I export an Access table to Excel, why do I see two vertical characters where the line separators should be?
Can I import a named range consisting of a single cell in Excel?
Why does the number field with input mask appear as text in Excel?
Why do I receive the "Invalid setting in the Excel Key of the engines section of the Windows Registry" error message?
How do I export a graph from Access to Excel?
When I import an Excel worksheet, why do I get blank columns in the Access table?
Can I enter a non-named range in the Import Spreadsheet Wizard?
Why is the memo field truncated when I output a report to Excel?
Can I import a worksheet if a field name begins with a space?
When I import an Excel file, why do I receive the "Could Not Find Object" error message?
How do I programmaticallly import an entire Excel worksheet into Access 2000?
Why are fields that contain totals missing from my report when I export it to Excel?
Why does the Import Spreadsheet Wizard display currency from an Excel worksheet incorrectly?
When I use "Analyze It with MS Excel" to export a table, the table is exported to an Excel 5.0/95 Workbook (.xls) format. How do I export the table to a later version of Excel?
Can I import numeric field names with the TransferSpreadsheet macro action or the TransferSpreadsheet Visual Basic method?
Why does text change to scientific notation when I output an Access report to Excel format?
Can I export a report with a datasheet form as a subreport?
How do I preserve trailing zeros when I import data?
Why are linked tables missing from the list of tables to import?
Top
Word
How do I use an Access report as the main document in a mail merge?
Why do I receive an error message on a report with a subform when I use the "Publish It with MS Word" feature?
How do I import a Word table containing carriage returns?
Why does the Export to MS Word for Windows option create a file that has a .txt extension?
How do I import Word mail merge data files into Access 2000?
Why do I receive an error message when I export files to Word mail merge format?
Top
Works
How do I import a Works database into Access 2000?
How do I import spreadsheets from Works into Access 2000?
Top
FoxPro
Why do I receive the "ODBC Call Failed" error message when I export a table by using the Microsoft Visual FoxPro ODBC driver?
Why do I have a Double data type rather than a currency data type when I export an Access 2000 table by using the Microsoft Visual FoxPro ODBC driver?
Can I export to a folder other than the default database folder when I use the Visual FoxPro ODBC driver?
How do I import, link, or export to FoxPro format?
Top
SQL Server
Why doesn't Access build an index when I export data to a SQL Server back-end database?
How do I use DTS to export data from Access to SQL Server?
When I export to SQL Server, why do I receive the "CREATE TABLE Permission Denied" error message?
Top
Visual Basic for Applications
Can I import modules from a protected VBA project?
Why do I receive a corrupted VBA Project error message when I try to convert a database?
Can I trap import errors in Visual Basic for Applications?
Top
Working with Earlier Versions of Access
Why do I receive the error message "Current user account doesn't have permission..."?
How do I share an Access database with multiple versions of Access?
How do I use a one-file database with multiple versions of Access?
How do I convert an Access 2000 database to Access 97?
How do I convert previous-version Access databases to Access 2000?
How do I enable a previous-version Access database in Access 2000?
Why do I receive an error message indicating there were compilation errors when I convert a database from an earlier version of Access?
Why do I receive the error message: "You don't have permissions to import, export or link to '<tablename>'" when I try to import objects from Access 97 into Access 2000?
Can I open or convert a previous-version Access database?
Can I import or link data in an enabled database?
How do I convert a database with non-US English characters?
Why do I receive an error message when I convert or open a database created with an earlier version of Access?
Why do I receive error messages when I attempt to convert an Access 2.0 database to Access 2000?
Why do I see unexpected or extended characters after I convert a database that was created in an earlier, localized version of Access?
Top
Working with HTML, ASP, or IDC files
Why does an imported Data Access Page retain the original data source?
Why do I get an error message and import fails when I try to import objects from another database?
Why do I see all records rather than a sorted recordset when I browse the exported file in a Web browser?
Why do I receive an error message stating that I cannot open the Access table in Design view?
What formatting is lost when I save an Access report in HTML format?
When I output a report to HTML format, each page of the report is exported as a separate HTML file and the file name contains additional characters. Why?
Why do I receive an error message when I export a SQL-specific query to HTML?
What happens to blank records in a table when I export the table to HTML format?
Can I import or link data from a remote HTTP server?
Does navigation work in an HTML document that was created in BiDi?
Why do I receive an error message when I use the TransferText macro action to export an HTML or text file using a specification table?
Top
Interoperability with Third-Party Programs
Why do I receive an "invalid operation" error message when I export an Access table to Paradox 7-8?
How do I use dBASE data with Access 2000 and Jet?
How do I use Paradox data with Access 2000 and Jet?
Why is an INI file created when I export from Access to Lotus format?
Why do I receive a "Disk or network error" message when I export a Paradox or dBASE table?
Why do I receive the error message: "The Microsoft Jet database engine could not find the object" when I import a dBASE, FoxPro, or Paradox file?
Why do I receive the error message: "The Microsoft Jet database engine could not find the object" when I import a Lotus 1-2-3 file?
Why do I receive the error message: "Invalid setting in EXCEL key of the Engines section of the Windows Registry" when I try to export by using the dBASE 5 ISAM driver?
Why do I receive the "Couldn't find object queryname.dbf." error message when I export a query in dBASE format?
Is there a Btrieve ISAM driver in Access 2000?
Why does exporting an Access 2000 table with a primary key field to a Paradox format not create an index?
What are the differences between native and linked tables?
Top
Last Reviewed: Tuesday, February 13, 2001