Alrighty - here is the setup...  I have two access databases (Address-Old
and Address-New).  The Address-Old database has a table containing outdated
information and the Address-New database has a table with the updates.
I want to merge these two database tables together so that I ...

I want to print specific pages of my contact list in card format so I can
have a "hard copy" of changes made to my contact list.  How can I print a
specifc page or a range of pages without printing my entire contact list?  I
have exported my contact list to a file, but I am ...

Help!  I have a 'single flat' access database of over 7400 client records
that I would like to export into the small business customer manager.  Is
there a way to do this?
thanks in advance!!

When attempting to copy records from a table or query using the ctrl-c
command access periodically freezes.  I can see the "Copying in progress" msg
in the bottum left corner of the screen but it seems to freeze on this.  This
error seems to occur more often once the table or ...

1. What tool and script do I use to automate the importing of data from
various Excel spreadsheets into previously set up Access Tables?
2. What tool and script do I use to automate the Exporting of data from
various Microsoft program sources [Outlook Contacts, etc.] into ...

When I export to Excel, if the Excel file is already open, I get the error
message:
Table <name> already exists. (Error 3010).
I'm new to exporting..... is there any way this error can be avoided (other

How do I run stored SQL Server procedures or view queries from an mdb? Thanks.

I have an Access 2003 database that is updated frequently and one of my
co-workers needs to access one of my database tables in his database, but he
doesn't want to accidentally modify my data.  How can we link the table he
needs into his database as a read-only table?

I have no idea how to integrated or link our billing and database in one
place. I try to modified already template but not appear as my wish. TQ

I would like to rename text  file on server after importing it. Maybe to  
something like imported_filename.txt.
Currently I can import just fine but I'm stumped when it comes to renaming
file from access. Here is the code:

I am having a real dilemma, and am hoping you can help.
I have exported a text file into an Access (2003) table, which contains one
column comprising of Group headers and the members of those groups, like this:
[Group1]

When exporting a file to Excel, is it possible to automatically include the
date (and time?) that the export took place in the filename?
At the moment, I'm using a command button to invoke the export.  Here's the
code:

I am using Excel 2003 and Access 2003.  I have a spreadsheet with cells
that have currency values in them.  I reformatted the cells as general.
 When I try to import them into Access using the wizard I get an error
message.  The message is An error occurred trying to import the ...

I'm struggling to convert long integer into time format.
The data is mixed and in the following 2 formats 141030 and 91017.
Some of the time has 5 and the others 6 numbers.
So i'm trying to get both into the following format 15:10:03 PM-

I've got a comma-delimited file text file to import to Access. However, each
element between commas contains the Field Name followed by an equals sign
followed by the data (e.g., PolicyType=Standard, PolicyName=NewPolicy). The
elements are not positional; they do no occur in the ...