While using an Access project(Acc2000) I would like to link the
project to another database (same Server) that is identical according to table/views etc
In this way it is easy to swap production and test
How can I easily swap database because there is no way to link tables,

We have a query which includes several date fields.  When exported to Excel
2002, the date fields change to text, and only through several steps can be
changed back to date fields for use in pivot tables and other analysis.  Is
there an easier way to ensure that all date fields come ...

If I export a form to an Excel, the format in the form --
font, cloor, bold--will be maintained in the Excel file.
If I export a table to an Excel, the format is gone,
although I have set the color and everything in table

I have an application which programatically imports data
from excel spreadsheets. When I run this on my home PC it
works normally.
However, When I run exactly the same application on

I need to export a table to Excel. The table has a field -
- CallTime--with time format. When I exported this table
to Excel, everything else is cool except the time format
is changed.

How can I change the path name in MSysObjects 'DATABASE'
column?

Hi,
I have two access based programs
I joined the two databases and copied them in to an sql
database only problem here is that I had to change the

I am trying to export an two Access tables to an xml file,
the tables have a relationship joining the tables. When I
open the main table in the datasheet I have a plus (+) in
column row against each row clicking the plus shows the

Is there a routine that can be downloaded to link or
import Microsoft works wdb files into Access

Is it possible to link a cell in an Access table to a
single cell in Excel.....similiar to the way you can link
an excel cell to another excell cell in a different
spreadsheet?

I have several files that link to several different ODBC
sources.  Many times when I make joins to match the data
the one database has different formats than another.  
For instance, AccountNumber from database A might is

I typed our client list into a table in access 2002 last
year. I was asked last week to place them in a combo box
so users would not mistype them and make it faster
entering them. There are 198 clients, is this possible?

Each month I receive the same spreadsheet with updated information.  I want to import it into Access and replace last month's import but I don't want to lose the queries and reports I've built.  I want those queries and reports to work on the new import.   How do I do that?

Hello.. and thank you for participating in this awesome site. I have a problem that I hope someone has a quick solution for as I am pressed for time.
The following code searches a directory and imports all data from all .xls files in that directory. This works fantastic. The ...

Not sure how to look this up in the help menu so...
I have 2 separate excel files.  #1 is a small list where  
Column A is filled in with a number.  Column B,C,D are
blank.  Excel file #2 is a larger list, and column A