Technote Details :: The exported CSV file does not contain all records

I have created a CSV export page using MX CSV Import-Export. The application uses the ASP VBScript server model and an Access database. When checking the CSV file, some columns on the first row do not show.
In the sample below, the address for the first company has not been exported.

This happens when the database has a memo type field, and you use a connection string like the one below:
"Driver={Microsoft Access Driver (*.mdb)};Dbq=<path>\database.mdb;"A memo type field allows the user to store more than 255 characters. In fact it can store up to 65,536 characters, which makes it useful when you need to save descriptions or other type of content.

In order to correctly export memo type fields information, for all records, you should use a connection string that specifies the provider. A good example is:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=<path>\database.mdb;" Use this type of connection string when defining the database connection in Dreamweaver in order to work with memo type fields correctly.

Login to add a new note