Re: Accidently Deleted a Table

Techy Wannabe <jamiepowellsmull@xxxxxxxxx> writes:

Ok, a customer accidently deleted a table from a FM 8.5 database. I
have a back up copy of the database but not a copy of the original
excel file used to create the table. I cannot deploy the back up copy
of the database because the customer has made extensive changes to the
database and all the info would be lost.

I would like to replace the missing table and I tried creating a new
layout and putting in all the fields of the back up table and I got a
message stating that the data would be truncated.

The numbers are a mess and the data doesn't make sense.

Does anyone know how to copy a table and put into another database?

Thanks!

You are going to change your backup strategy after this experience ...

Jens

--
A: Because it fouls the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?
.

Relevant Pages

  • Re: Opening Excel from Access
    ... I have a form with a textbox to hold the Excel file name and a command ... Dim MDBName As String, DefaultDirectory As String, SQLStg As String ... If MsgBox("Do you want to use this database in future?", ...
    (comp.databases.ms-access)
  • Re: commiting changes made to a typed dataset
    ... submits them to an sqlserver database. ... finally all the added rows have to be submitted to the datasource ... is the datasource of the dataset the Excel file or the sql ... but this is a classic ADO newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Opening Excel from Access
    ... Please post the code that is in the Excel file. ... There is some code in the Excel application which refers to the Database ... Dim XLFilePath As String ... Dim Msg As String ...
    (comp.databases.ms-access)
  • RE: Error in docmd.transferspreadsheet?
    ... Try to create a new Excel file, and add some simple fields/data to test ... try on a different client machine with Access 2003 ... If the issue still occurs, please try a different SQL Server as backend ... "restarting the database" I mean close and open the adp ...
    (microsoft.public.access.adp.sqlserver)
  • RE: exporting an excel file into an access table
    ... Dim dbNew As Database ... Set dbNew=OpenDatabase ("path and remote database name here in quotes", ... Once you have the remote db opened, use an append query to do its job. ... The problem for me is exporting the Excel file from my PC ...
    (microsoft.public.access.externaldata)