I am using following method to export a table to Excel:
DoCmd.TransferSpreadsheet acExport, , "tblReport", "C:\CAIMPKC\CA_Imports.xls"
But it is not replacing the existing file, it just adds to it causing the
file to double/tripple, in size.  It is also not formatting it, i looks ...

 I have a text file I want to import into an Access table.  My problem is
that each line of the text file doesn't correspond to a database record.
Essentially, each record of my table will consist of 3 lines of the text
file, read consecutively.  i.e., lines 1-3 become the first ...

At this moment, I imported some tables from ODBC Databases into Microsoft
Access, made some changes, and trying to export them back to Oracle Database.
I had about 10 tables imported and every table except one table had no
problem exporting. But when I try to export the last ...

This is my first time working with importing data.  I have payment files in
excell that I want to import(but only two of the fields out of several) into
an existing Access payment table.  
Payment table (Access) consists of following fields:

I am trying to link Outlook contacts to an Access Database -- when using the
Get External Data-Link Tables the resulting table does not contain all of the
Outlook Contact fields and I cannot figure out how to get them to link over.

How may I specify fields from Outlook Contacts which should be linked to an
Access Table? Can't seem to get the Business Phone number field to appear in
the linked Access Table.  Failing this, can I specify in Access the fields
from Outlook Contacts which I want to import into ...

I often import query objects to an empty "holding" MDB file to send them as
an email attachment to another user for importing into a copy of the full
database that I have. I do this so that I do not have to email the entire
database file, which can be 100+ MB in size. When I used ...

Only part of my imported data from excel is incorrect when using the macro
function (TransferSpreadsheet - import).  However, the data is good when
imported it manually.  

Trying to write from a table in Access directly to an existing Excel file.
Cant use MSQuery, and dont want to do TransferData, want to write directly.
Can create a blank file and write to that page, but dont know how to write
code in Access to call the existing file as the one to ...

I am working on a routine where if you put in any value, it looks
through all the tables of any database for that value.  Currently, I am
at the point where a table is created with three columns.
Here is an example of the table that is generated:

When following the instructions at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/ac
howImportAttachSqlDatabaseTablesS.asp
the link table wizard suddenly disappears (Access 2000 returns to normal
database view) when I double-click (or single-click for ...

With the command TransferText, I've tried to export data from an Oracle
database with a pass through query to Excel. The answer of Acces is:
Operation is not supported for this type of object.
My question is, is it possible to export to Excel with a pass througt query

I need to link to an excel file, but I need to normalize the spreadsheet data
that contains columns of data that needs to be converted to relational
records.  I think I said that right.
Excel file:

I'm trying to automate word; at first, with very simple code:
********
Sub automateWord()
  Dim wordApp As Word.Application

I am creating Access DB for my church.  There will be two seperate
hierarchical databases that mirror church administration.  DB1 will focus on
the local parish while the DB2 will be for the diocese.  
Question