I want to import data from dbase3 to a spedcified table in Access. Every time I try to import the data, Access creates a new table. But I need the data to update an existing table. Are there any suggestion that would help
Thanks
Le Tran

I have a program which we bought that is a billing program
that doesnt have all the reports that we want. What I want
to be able to do is to get at the data using a form that
we can use to both update data as well as see certain

Im using MS access 2000, i've been trying to import a .txt file but it
doesn't work, i've tried a few times importing other file types and
they work fine. Anyone know how to help me, this is really bugging me.

Can you help me?   When I try to output something in
Access I get the following error:
Microsoft Office Access can't start ole server.
I'm exporting data from Access 2002 to Excel 2002.

I'm running Access 97 and I am importing data from Excel.  
I am encountering import errors as a result of access
reading the first row of the excel spreadsheet for field
type determination.  Some of my fields begin with a number

How would I go about linking one field to another?
ex:In one field I have the numbers 5276
I want to link that field to another so that it
automatically enters in another field.

Using the Action acOLECreateEmbed property with an Excel worksheet to an Unbound OLE object on a Form.  VB executes fine (.class, .OLETypeAllowed, .SourceDoc statements working without errors).  Then it halts at the OLE1.Action acOLECreateEmbed statement
Run-time error 2793... ...

I am trying to import a xls file into an existing table in
MS Access. I am needing to replace the existing data in
the table with the new data from the xls file. (i.e. we
need to change all the data in the table with all new data

I link my database to some AS400 based tables.  Recently,
some queries have failed to run with the message "ODBC
call failed".  However, I can open and view the tables
through Access.

I'm trying to import an excel 2000 file into my access 2000 database and keep getting an error message with no explanation.  I am trying to import the file into an existing table in my database but it won't work.  When I import into a new table in the same database it works fine. ...

I am importing from a text file using the following line of
code:
DoCmd.TransferText acImportDelim,
"CBC_Import_Specification", tblName, Me![FileFolder], False

Is it possible to import data from an Excel spreadsheet
into an existing Table and have the data populate in a
field on existing records?
For example, I have a database that contains Customer

I have a dev MDB and a production MDB.  I've created a
Import/Export Specification in the Dev MDB and am now
trying to port it to the production.  Is there a way
to "import" an Import/Export Specification easily from one

1.  I have a table (linked text) called "inp" and another table called
"holding".  Can the linked text table be opened as a Recordset?
2.  I want to transfer data from one RecordSet to another.  The text file is
scrambed pretty good, but it is sequential, so what I need to do is ...

I have 20 pages access report. I want export each page to
different excel sheet in the same workbook?
Thank you in advance,
Adis