Hi,
Does anyone have an idea of how to automatically import data from one table
to another within the same database, based on just one of the fields filled
out in one table. Both the tables have same fields names and one of the

I am doing an access Data Base for Independent Contractors for a home care
business and need to know how to import new contractors from excel to access
2000 or can I hand type the info in?

Anyway to connect to an IBM Mainframe DB2 server.  I think the ODBC driver
assumes a windows DB2 or maybe LINUX.  Someone correct me if I am wrong....
  Jason

question: I received several csf files but when you open them
they open in excel format, is there a way ti import all these files
into 1 access table??? Does anyone have sample code that shows
you how this works??? many thanks for any help or suggestions....

i received several csv files that I urgently need to import
into an access table.  When opening the cvs files they open
in excel, is there a way via code ti import all these files?
Does anyone has  sample code that shows you how this works?

Why is it that when I go to import a text file using a file spec that I
either just created on the fly, or one that had existed, no matter what one,
I get the following error message: the text file specification, <specname>
does not exist. You cannot import, export or link using ...

I know that it is possible to export an entire table to a csv file, but is it
possible to export only part of the table? (i.e. Have a prompt for a date and
then only export that date?)
I am using Access 2002 but with 2000 file formatting.

I am importing files with USB flash drives and need to designate which drive
the data is coming from. The VBA I am using does not work. Any help on this
would be greatly appreceated
Function IImsImport()

Hi. Am trying to merge data from an MSAccess database, into MSWord using
Office 2000.
However, when I select the merge option in Word, and point to the database,
Word hangs and the progress bar displays "Waiting for Access to accept DDE

Could someone please tell me what a question mark means in the Linked Table
Manager.
My tables are linked to other tables, I understand the Globe, but some have
a ? - I have no idea why....

with Access 2007, I noticed that the facility to link to an excel sheet
specifically mentions that "source data can not be changed from within
Access".
I was able to carry out SQL updates in Access 2000, how can this

Ever since I have started using Access 2007 I have been getting Import
errors,All it says is "error in loading DLL".
Any ideas on how I can fix this?

I have a weekly statistics report that comes out in Excel.  It has some
historical data and the user has to do vlookups to compare with last weeks to
find missing data.  It would be much better in Access.  What I want to know
is should I figure out how to do the structure how do ...

Is there a known problem with ODBC connection from Access to Word mailmerge
on Vista? I have a database that opens Word using ODBC and sends data to
mailmerge fields. The code has been tested and running fine on other versions
of Windows (2000, XP...) but, I recently purchased a ...

How its possible to insert S.No. or Count (No. of records) in report?
Thanks & Regards
Hassan