blueshell Forum

Hi Ruth,

Yes, you can!

See "Exporting a table" in the help or in http://www.blueshell.com/EbDg.asp .

Act like this:

1. Create and open a new Jet database
   Select File→New→File Database... and specify a filename and filetype.
   


2. Open your mySQL database
   
   
   
   1. Start blueshell Data Guy
   
   
   2. Select File→New→OLE DB Connection, the Data Link Properties dialog appears.
   
   
   3. Select the mySQL provider and press Next.
   
   
   4. Enter the info for your connection and press Test Connection.
   
   
   5. When tested successfully, finally press OK.
   
   
   6. The connection is opened and you can now select your table from the tree view of the Connections window.
   
   
   
   


3. Export your table to the Jet database
   
   
   
   1. Define your source recordset
      Open a table from your SQL Server connection.
      
   
   
   2. Start the export
      Select Export from the Table menu or press the button from the toolbar.
      
   
   
   3. Choose the destination
      Simply click the Jet connection of the tree view.
      
   
   
   4. Press Start to start the export
      
   
   
   5. Edit the details of the export process
      Fine-tune the structure of the new table and specify which source fields will go to which destination fields.
      
   
   
   6. Do the transfer
      Press the OK button. Watch the progress bar. You may interrupt the process by pressing the Pause button. You may abort the process by pressing the Stop button. You may specify error actions when an error occurs. You may even watch the source and destination (or any other) table during the transfer.
      
   
   
   7. Decide whether to commit or to rollback
      Finally you may commit the whole transaction or you may rollback it.
   
   

If you have any further question, please don’t hesitate to contact me again.

Best regards,

Harry