I have an Access table created from an Excel import.  Fields withing the
Excel worksheet are frequently updated with new information.  For example,
contact names change, or records are added or deleted.  How do I import the
new data and get Access to automatically compare with ...

Every hour, 2 CSV files, with a naming convention reflecting the date and
time of their creation, are added to a directory on a server. I can easily
determine which one of the 2 I am interested in with an instr function which
will return 0 for the one I'm looking for. However, ...

I have a main address book, and I would like to import or create another
table for a Christmas mailing list, using some of the entries from the
address book.  How do I import or transfer only selected entries from the
main address book to the new Christmas mailing list??

I have a database that opens an import file, formats the data contained in
the import file for export to our mainframe, and reports on the data. The
import files for this database are named by the date they are generated, i.e.
bd112805.ok. I want to be able to have Access ...

I have a client who requires a csv file, currently created from an excel
spreadsheet.  He wants to generate the file from an Access database.  If I
create the csv file in Excel the text fields do not have double quotes ""
enclosing them, however if I create the csv file from ...

ENVIRONMENT:  Windows XP Pro, Office/Access 2003 Pro.
Situation:  to keep DB size reasonable and avoid "invalid argument" errors
generated when DB approaches 2gb, some tables are kept and periodically
updated in separate DBs, then linked to other DBs that make use of them.

I have an Access table that contains dates. If I select and copy the text of
a single data field, I can paste it into an Excel cell with no problem.
However, if I copy the entire cell (or a column or row of cells) from Access
and paste it to Excel, all of the resulting dates in ...

How do I import or link an foxpro table to an Access database. I use access
2000 and fox pro 8.
In access 97 it is easy but I cant find out i access 2000.

For years we have been using Microsoft Access to transfer data to/from an
AS400 using the Client Access ODBC connection.   We are now having problems
with the connections where the data looks garbled when you open a table, or
it will say #DELETED in the fields.

I have certain tasks in an excel spreadsheet that also have deadlines next to
them. Can I automatically generate a event on my outlook calander with excel?

hi to all of you... I am importing a word document that some people send to
me and at this point, I cannot choose which document I want to import.
My code is the following:
Dim oDoc As Object 'Word.Document

Hello, everyone.  Is there a way to force Access to use the date format that
Oracle likes (dd-mon-yyyy) when performing an export.  I cannot get any other
format than mm/dd/yyyy.  I am exporting to a .csv file and then loading into
an Oracle table using sql loader but it does not ...

We have a PGSQL database which sits behind our support ticket management
system, which is version 7.3.4.
One of our employees uses an Access report to view and print out the
information contained in certain fields, those used for showing what work has

i have a data table that i've established relationships to in a query.  i
want to be able to re-import data into the table and have the table be
overwritten with the new data without loosing the relationships.  also, the
date from the table is in the format of yyymmdd and i can ...

I am trying to import an Access Database to another Access Database. It's a
calendar. There are things hidden in the calendar 2005.  I have clicked the
button that says show hidden objects to bring it back but the hidden objects
still stay grayed out. When I import the caledar to ...