Import or link data and objects - Access - Microsoft Office OnlineThe trick is to first import just the structure, then change the datatype from text to Memo where truncation is occurring, then use the append feature.
1. Open a database, or switch to the Database window
2. On the File menu, point to Get External Data, and then click Import.
3. In the Import dialog box, in the Files Of Type box, select XML Documents (*.xml;*.xsd)...
6. To start importing the file, click OK . This completes the import procedure.
Note For most records that cause an error, Microsoft Access creates and adds a row to a table called Import Errors. To view the list of errors that were encountered, open the Import Errors table from the Database window.
7. To set options for importing, select one of the following under Import Options:
* To import just the structure of the table, click Structure Only.
* To import the structure of the table and the data, click Structure and Data.
* To append the data to an existing table, click Append Data To Existing Table(s).
Monday, November 20, 2006
I recently had to import some XML files into Access. It worked well, save for text truncation. Here's the process, the workaround is below: