I'm trying to import into Access 2000 a large fixed-width text file: 150+
fields, 1401 characters wide, and 79k+ records. During the import process,
instead of seeing the data, I see question marks and crosses. I made a
smaller sample of the file (76 records), and got the same ...

Sorry if this is not in the best group.
I am trying to create an XLS file using SQL statements in a C++
program.
All works fine, except that each table I create is on a different

I'm working on a project with an excel database and need help with the
following.
This database has some dates that are changed regularly and I need to
make an automated

Dear gurus
I would really appreciate some light in the dark. I have a problem with
Dlookup in Access from Excel.
The code below does the following:

I am new Access User, because Excel will not open the this Big File (it does
open 65000 lines perfectly) It is an 800,000 KB DAT file. When I Start Access
and then try to Open the DAT file I get the message "Unrecognized Database
Format (followed by the file address). I tried the ...

I am trying to import data into excel in the form of a table/matrix for ease
of viewing some of the data in my access database.  I have a table of
Controls, a table of Risks, and a Table that is connected to the other two in
a many-many relationship.  The goal is to have the ...

Let's say I have a customer's name entered in Sheet1 at A1 (file name
(MyExcel)). And there is button right by it. I want to assign a macro to that
button that it can transfer this name to my access file called MyAccess
(assuming that I have a table called "customers" and it has ...

Does Access 2003 support OutputTo -MS-DOS format? When I converted my Access
2000 to 2003 -  MS-DOS format option is no longer available. Is there a way
to get it to work?

Firstly, sorry if this has been covered a hundred times before.
I'm creating a table in Access, defined fields and validation rules.  I
import a text file into the table.  One record is rejected due to validation
checking as intended (this is an educational exercise).   BUT, ...

Even with the cursor speed in Word set to Fast, it's not fast enough.  Anyway
to increase cursor speed.  Anyway MS might write a patch to allow Word user's
to increase cursor speed should they so choose?
----------------

I need  to export my report in .rtf of .doc format with picture but when I
export it the picture and line disapears? Please help me.

I am trying to import financial data in a European format from a fixed-width
.txt file to an Access 2000 database, using Access 2002. The format is as
follows: 1.000.000,00 positive numbers and (1.000.000,00) for negative.
The wizard does not seem to allow to change the thousands ...

I am working in  a MS mdb. I have another mdb database say School.mdb . To
link to a table form school.mdb i use:
    DoCmd.TransferDatabase acLink, "Microsoft Access", _
   "C:\School\School.mdb ", acTable, "StudentsMaster", "Stud", , True

I have successfully transferred some data from a table in my database to a
text file in exactly the format I want using the Export Wizard. Then I come
to automate the process via either a Macro or VB. When I trigger the
TransferText command I get

I am getting a Access 2000 error message stating  "Cannot define field more
than once" when importing a Dbase IV table into Access.  I have imported the
exact table several times before.  What does this error message mean and what
can I do to fix the problem.  Thanks in advance.