This is going to be my first attempt to import data from one Access database
to another.  While it may be a simple and routine task, having never done it
has me unsure of what to do.  I really appreciate any guidance anyone has to
offer!

Access 2003:  Problem:  I cannot append to a linked Excel spreadsheet.  From
what I've read in the posts, that's because there's no primary key.  The link
wizard did not prompt me for a primary key, so I suspect the answer lies in
creating a "local index".  How do I do that?  (Or ...

I have a macro that automatically exports the results of an Access query to
an Excel Spreadsheet. It does this on a daily basis.
Up until last week, the tab on the spreadsheet would be overlaid with new
data.

There is a large amount of waste space that accumulates during import.  My
database has gotten large enough that I have to compact & repair the database
half way through the file imports in order to avoid the 2Gig file size limit.
Is there any way to set up Access to minimize the ...

I want to have a letter that will import information from a database (names,
addresses, and such) so that I don't have to spend time cutting and pasteing
as I do now. Is there an easy way to do this?
Thanks.

 I'm trying to import data from a db I created that has the VB code
password protected, when it gets to importing the forms with the protected VB
code it comes up with an error saying I must enter the password for the VB
code but it does give me an opition or say where the ...

Is there a way to embed an .avi file in an Access database and use media
player to play it on a form?

I have an existing import spec, and I am trying to add fields to it.  Once
the field is added I choose Save, and the new fields are removed.  I can
change existing fields, but am unable to add anything.  This is incredibly
frustrating.  Does anyone know what is wrong?

I seem to have fallen over at the first hurdle and need your help:
I receive an email first thing every morning with a data link in it
like this:
https://esales3.nj.ssmb.com/esalesauth/ReportAccess.smvc?Resource=/ftp_p

I have 3 tables and I populate each by importing 3 spreadsheets.  The 3
spreadsheets are basically set up the same way and on all 3 spreadsheets the
1st row contains column headings.  The spreadsheets are created via VBA by
extracting data from a series of formatted spreadsheets ...

I need to update my access file which is available through internet
i.e. http.
What are the different ways avaialble for this?
I tried liking that table at my client application which is again a

I want to import a MS Word file to a new Access data base table. I continue
to get the message that I cannot import because the "object" is read only,
and yet I can open the document and edit it in any way. What is the problem?

I have a tiny db that imports a txt file, deletes some rows, does some
calculations, deletes the file and then prints out a report. (quick
explanation)
To make sure there is only one file imported, and also the correct one, I

I have an Access application that imports Excel spreadsheets into tables
using Transfer Spreadsheet Macros.  However, The default database folder
keeps changing and the following error keeps coming up when a transfer
spreadsheet macro executes:  "The Microsoft Jet database engin ...

Every day I run commands that truncate a table (tblSAR) and import new data
from an Excel worksheet.  All of a sudden I am getting a Type Conversion
Failure for the date fields.  I can see that some of the dates in the Excel
worksheet are in the format mm/dd/yyyy (with a leading ...