Importing from XML. Field width issue.

[samehkh]

We are importing data from XML files manually to an access Database.
The imported tables are all text fields with field width 255.
Some text fields are too big and we end up loosing some records as import errors. Is there a way to let access generate an imported table with a text field that is longer than 255 character ?

 

[Dennisk]

change the text fields to memo fields

 

[samehkh]

I do not have control over that. When I import the tables from XML the field type is automatically selected. If I change the size after the import the date is already lost so it wont help.

 

[Dennisk]

why can't you change the data type of the import table?
are you using an import specification?

 

[samehkh]

We delete the tables every time and import them fresh from an XML file. Import specs works with text files, but I could not get Access to use it with XML.

 

[Dennisk]

The normal technique is to set up a correctly data typed import table and prior to importing, delete the contents of the import table.