I want to import from a txt file with a list of name
which is separated by a newline character into Access 2000.
File like this
____________________________

We are having a problem using the TransferText method to export to text.  It is coming up with an error similar to run-time error 3625 described in the Symptoms for article 241477.  However the only solution listed pertains to importing text.  Is any solution possible for ...

Hello, need help please:
Trying to output  information from a query to a named range in excel,
the problem is that the process results in every field in the query
being tranferred to each consecutive column in the range.  The problem

This is just a general question on technique.  I don't need specific
details.  I have an MS Access 2k front end hooked to an MS SQL 2k back end.
The main table in the system has about 30,000 records in it so binding the
form to the entire dataset is dumb.  I want to bind the form to ...

I am trying to create macro i want to export several
queries to one excel file. In the macro you can select the
OutputTo
Object type  : Query

Is there anyway you can set up a scheduled export of a
query in Access 02.  EG I have a sales query that I want
to export to XML format every day to send to our data
warehouse - I don't want to have to manually run the

a true newby here,
    I have created a data base here based on orders in
an excell spreadsheet. My problem is from one day the
next, the info in the spreadsheet changes with new ones

I have all of my old client records in an old Dos version
of Dbase (2+ i think).  Any suggestions on if and how they
can be converted to access.
Thanks in advance for any suggestions.

I am struggling to reconnect an Access97 mde file from our EDI application
to a new sql database. It has been working without error for years as is. We
have just replaced the back end from access to sql.
I have created a system DSN and manually linked the tables removing the dbo_

When trying to import a Dbase IV file I get the following
error:
Microsoft Jet database engine could not find the
object. . .

The following article claims that Access 2002 is also able to export data to XML
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2k3ta/html/o
dc_acxlom.as
but I am unable to locate information about the ExportXML() method in either the Help or by looking at the ...

How do I do to link a table of SQL SERVER directly to MSAccess 2000 without
ODBC?
_________________________________________
AlternaTribe

Can anyone shed some light on this....
My Sub-routine is declared as follows
Public Sub ImportFile(strPath As String)
The cmd button code is as follows

I have a database with a linked Excel table. I use an add
query to import new records from the linked Excel table to
an Access table.
I experience the following problem: if the linked Excel

I have a donors form. When a donation is made, I would like to hit a command button to open an existing word document (thank you letter), insert the donor's name, address and contribution into the document and print it.  Is there a way to do this all within Access
Thanks.