I have an updated database that has some new information
but mostly are duplicates of what I currently have in the
original file. I want to combine the two dbases with the
output (new table) so only the new entries are shown. Does

I need to Export the design of a Report ie., Report Object
from one database to another. I am using the
Application.DoCmd.TransferDatabase method, but not able to
export a report design object. Can anyone please help me

Windows 2000 Server, SQL server 2000 with Access 2000 frontend
Hi all,
We have a database that holds all our project data and a fileserver
that holds separate folders for each project. Folders on the network

I have two databases, a client db and a planning db. In the planning db I
need client information which is stored in the client db. I tried to link
the main table from client db in my planning db but I could not set the 1:n
relation type.

We have an Access database which is shared out to two
people.  The primary (owner) of the db has no problem
using the files.  When the other user uses it, she can
access and make changes, but when she saves it, it

I don't know where to post this question, but any help is
appreciated
I have a database that keeps track of all customers and
invoices.

Is there any other way to change the folder for a linked
table except Linked tables manager?

What's the best way to label data that I export to
Excel?  I want to mark the parameters of the query (for
example, the start date of the data) on the spreadsheet,
so when I send the spreadsheet to another person, they

Hi Saviour,
I'm currently encountering problem with my import from
Excel to Access table. The excel data has the similar
field name as the table. However those data with "Alpha-

I'm creating a report.  I have a number of query and
calculated fields in the report.  The report should only
be 1 page long, but for some reason there are 11 (the
number of calculated fields).  How can I remedy this?  Any

I have an extensive database in Lotus Approach and am in
the process of creating a new database in Access with the
same information.  The Approach database has several drop
down lists, automatic dates, etc.  I am having trouble

I'm very GREEN regarding FTP's and the like.  But I need
any guidance you can share in regards to a flat file that
is ftp'd to the web.
We have data that one of our areas are taking directly

Has anyone come across a problem selecting the Data Type in Access 2003?  That choice is greyed out and I can't seem to  select different columns either.  I feel like I must be missing a setting somewhere?  Please help, I can't import properly without some kind of control over ...

Dear Sir/Madam.
I'm trying to transfer data from a table to an xls file.  
Everytime I do, the headings from the table show up on the
first line in the xls file.  How can I eliminate the

I've developed an Access 2002 database, where I need to
have the ability to automate exporting data from the
database to an Excel spreadsheet.  
Does anyone know of a good source to complete this task?