I am currently using the following code to import data into a table from
excel but am having problems:
   Dim appAcc As Access.Application
   Set appAcc = New Access.Application

I'm wondering if I can do something on access using the linked table
feature.
I'd like to create a mirror of a unix database (we have odbc access to
it).  It's about 800MB.

Have an Excel spreadsheet linked into an Access database.  One of the
columns is determined to be a text field by the Access database being run on
one PC, and to be a number field by the same Access database being run on
another PC.  Both XP Pro, Office 2003 with all updates, ...

When I attempt to import an Excel sheet into Access 2003 I get an error
message,
"ActiveX component unable to create object"
I can't find any information on this error.

I am looking at creating a database whereby we can load a series of reports
which are then emailed to managers to self-certify, who then enter comments,
tick boxes etc and I want to be able to reincorporate this data into our
database again.

I'm working on a ticket writer database. Currently, it has about 10-15
ticket agents using it simultaneously. There is also a read-only 'ticket
portal'
which users may use the retrieve a ticket. This is an classic ASP web page

I have a report in Access 2007 that I want to export to XML data and I keep
getting two errors, one right after the other.  The files do export but the
HTML file size is zero and it does not display any data.  I'm exporting the
schema and presentation.

I want to change the location of some ODBC tables at will.
All the connections information is the same  except for the server name.  
Passwords, Username, all else is the same.
When I do this manually I use the Linked Table manager, select the tables,

I just upgraded to office 2007 and I am trying to link/import an external
database via ODBC but I'm not finding this option when I try to create a new
table.

I have a report which groups the data and only displays the group totals. I
would like to export it to excel - but just want the group total in excel -
it seems impossible to me but I hope somebody knows different. I'm a relative
novice so.....

I'm exporting two Access tables (that were populated by doing several append
queries) into an existing excel workbook.  The export is based upon a click
event of a form and I perform this export to the exact same excel worksheet
in the exact same excel workbook once a week.  ...

I get 20 meg files in Excel which are difficult to open.
The first 9 rows contain information not needed for a table. Row 10 contains
the column headers.
Can I specify which row contains the headers or which row is the starting

Can i export data out of local access database and copy the data to a FTP
location on a website?, how can i do that?. This need to happen on daily
basis, can I schedule a job?

Hi - I hope that i am posting in the correct category here. if not, please
let me know which category would be better suited.
I have a database file which seems to be corrupted. Running some (not all)
reports/forms or creating a new report/form causes access to crash and close:

I am sending data from Access to Word.  In Access there is a form with
selection criteria.  There is also a query that contains the selected data.  
There is code behind a form button that writes the data in the query to Word.
As each record is written the code selects the ...