Spanitz,

Can't you just export from the 1st database to a .txt or .csv file, then import into the 2nd database?


Steve

I've done the import/export and didnt notice any problems. I think as long as you dont touch the .csv file after you export, you should be fine but I would test it on a few records just to make sure.

I've seen Sesame "escape" some important characters on a .csv file created by another database program. Seems like if you maintain the same settings on both export and import, you should be fine.

You may want to use some "safe" settings, like using a delimiter that isn't commonly used in your data such as the pipe " | " (above the backslash key on your keyboard)  as a delimter and putting quotes around all of your data, just to be safe.


Steve

Hi spanitz....

You asked: Quote:


The term "database" is frequently misused here.  Could you please explain what types of databases you are are trying to  transfer? 

Do you mean a database within a Sesame application, do you mean a single database in Q&A, do you mean a database of tables in Access,FoxPro, or something else?

Are you trying to move a database in a Sesame application to a different branch within the same application?  Are you trying to move a database in a Sesame application to another Sesame application?  If Yex, is there already a database in the destination application with the same name?

You are trying to move some data from database type X to a new database type X or type Y?  Just need to move the data, or are you trying to move protramming, forms, reports, etc.?  It does sound like you only want to move the records.  Remember that Sesame can only import a comma delimited file at this time, so that will have some bearing on how you attempt to do this.

Spanitz,

The export tool is broken in ver 1.0.4. If your still having problems with import/export, hold off until they fix it.

Steve