For a user-friendly environment, I want to set up a command button to
automatically export a query into Excel.  Please advise the VBA needed.  

I can open a file but the file is not passing through with the code. Do I
need to write file and not line as follows:
Private Sub CreateAfile_Click()
Set fs = CreateObject("Scripting.FileSystemObject")

I have a form database which is linked to a table databse.
I created a new table in the table database from the form database using a
make table query (to split data into old and new records). Now when my users
add new records they are added to in front of the records, but in ...

Hello experts,
I have some Access forms with queries linked through ODBC connection to
Oracle.  Everything was working fine and all of a sudden I start getting the
following error message:

I have multiple databases that I want to merge into one table - I do not want
to use query - Any suggestions - thanks for any help.

Within an access-app I want to check whether a user is "Out of Office"
without having a Outlook security - pop-up.
Can anybody help me?

I work in a hospital lab. One of the analysers we use saves test data in a
new access database for each day.
I've written a macro to import the database into a user interface. When it
imports the new DB it duplicates the tables with the new data and adds a

I would like to combine two databases into one.  I exported the table from
database #1 into database #2.  I would now like to take that table and merge
it into a table in database #2.

I have a small problem figuring out how to do <subject>.
What i would like to happen is that I have a query defined in my Access
database, when i push a button, I would like to save this query as xml and
send it as an attachment to an email.

I use a program that imports into Excel that requires that the workbook is
closed prior to the import.
How do you check to see if an Excel workbook is open, and then close the
workbook?

I am trying to import data originally set up in an Excel spreadsheet and
everytime I do it I get the following message:
"Error creating primary key on field "ID" (index or primary key cannot
contain a null value)"

Just wondering if anyone knows of a method to create a form that allows you
to map data from a excel spreadsheet to fields in a access database.
I know how to create and import spec, but as our company has a number of
staff all adding data from excel reports I would prefer a form ...

Is is possible to update DBF files within Access. Can this be done in a
multi-user environment?

Access 2000 SR-1
Problem Description:
-------------------------------
I have the following query which I am using to export data into CSV

Please help. I have a spreadsheet that is used to import data in access
database. I opened MS Access -> Get External Data -> Import, then I got the
following error message:
"The wizard is unable to access information in the file C:\...Test.xls.