How do I link to a table stored in an Access database
located on a remote ftp site?

I'm trying to import a simple text file with one set of
10 character data in it, then a carriage return. I run
through the wizard to import the file, which is all
recognised fine, but when it's trying to import the text

My import blows up with the totally unhelpful message "Search Key Not
Found In Any Record."  After many hours of testing, reading and
Internet searching, it seems this message has all kinds of causes
(none of which help me).

I have created a link table in Access to a .csv file that
I download regularly from our company's payroll db.
I have 3 update tables that are dependent upon the SS#
field of the link table and another table in my db.

How to read from com1  port and write to text file
How to read and change com port parameters
Thanks

I was able to write code to generate an XML file from a table.  Can someone tell me how to now import the XML file back into a table?  I am using Access 2003 and am new to Access
Thanks
Michae

I am not sure if this is a MS issue or a security issue
within my office.  I am trying to automate the merge of
an access table to an existing word merge doc.  I have
docmd.transfertext

I was wondering how I could go about letting the user
choose the file to open for reading, instead of the
programmer.
My goal would be to create a diolog box that lets the

I'm using Access 97.  I'm trying to export a table to
a .txt file and getting an error message.  It doesn't like
the "text(*.txt)" line in the following statement:
DoCmd.OutputTo , "MyTable", "text(*.txt)", , False

When I import data from Excel to Access I can do this to a new table. No problem will sto
However, the option to import data from Excel to an existing table is always greyed out
What my doing wrong?

Hello.  When I import a certain text file into Access
2000, the text is replaced by question marks and
exclamation marks.  This same file can be imported into
Excel and even into Access 97.  Does anyone have a

SImple little question:  ... can access easily import a table/data from an Oracle or Mysql database?
In the "get external data"  I see all sorts of file formats but what format is oracle or mysql
Thanks for the help
Danie

I would like to import an excel 2002 spreadsheet of our
customers as a table in access 2002.
But every time i do this... once i click on file, get
external data, then import, and select the file i want to

I have a form with a 'print' command button that exports the data in the form fields from MS Access into MS Word form fields.  I've followed the instructions from http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnima02/html/im
a0102.asp.  My problem  is with the ...

I have an employee database.   I want employees to fill in a form to provided the data that the database stores.  I need to email one form to each user.  In most cases, the employee records are partially completed and/or out of date so the users will be updating fields in ...