Loading data into Pervasive tables

[irenavassilia]

Does anyone know how to load a csv file into a table with the Maintenance Load button in Pervasive v9.

I keep getting this error:

An error occurred during the access of the sequential file.

Thanks.

 

[grnelson]

Sequential files are not the same as CSV files. You might take a look at Btsearch32 at

http://www.nssdd.com.

It will allow you to import CSV files into Pervasive Btrieve files.


Gil

 

[dgillz]

You could use MS Access. Setup ODBC DSNs pointing to the CSV file and the Pervasive table. Then set up 2 link tables in Access, one to the CSV file and one to the Pervasive table.

Finally write an append query in Access.

If you are not familiar with Access there are several good Access forums here on TT as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[irenavassilia]

Thanks dgillz I'll give it a try.