A user of mine is having issues importing from Excel and
I cannot debug.  OfficeXP, Access2000, Excel(8).  
Here is the code, which for the life of me I cannot
figure out what is not working:

I want to do a mail merger from an excel spread sheet into a Word document.  
If there is $ involved the information merged into the letter is wrong.  For
examplet $24.06 cents will come as 2406.99999999999999991.

I am using TansferSpreadsheet to import into my
database.  I have 5 tabs in the spreadsheet and I am not
sure where in the Marco to put which tab I am importing.  
This is my Marco:

I can't find any reasonable information about hoe to
export Access query to HTML from code.
Can anyone help?
Jupy

Does anyone know if you can import a form from another
database and then check it against the database you are
importing to, to see if the record already exist.  And
also how would you go about doing this by a button?

I am exporting from Access 2002 to a text file using
DoCmd.TransferText acExportDelim, , "Table", "File"
However in the text file that is produced the numbers are
truncated to 2 decimal places. The table fields are

I have a Dell Dimension desktop using Access 2002. Want to
migrate my data files over to my 2003 Serever Enterprise
edition. Have Access 2003 on Server.
Questions:

Hi -
Simple question but long story below...
I am writing a code that imports specific 'Ranges' for an
excel spreadsheet into a column in Access.

Out of all the formulas I have the only one that is giving me a problem is a
simple addition formula.  Has anyone noticed an issue where the system wont
add correctly.
I sumed up 4 sells that consist of these numbers 195, 153 and 16.

I hope this forum can take me through a situation I need to get resolved in
under 2 weeks (11/1/04).
I am new to VB (and VBA) so please bear with me. Additionally I just
purchased VB 6 Professional so I can get familiar with the Object Oriented

Can I import into Access a .txt file with approx 900,000
records (rows) into Access.
The File Size is 210 MB (220,216,158 bytes)
This text file was so large it would not open. So I was

I am a rather new user to Access, so pls excuse me if this is an obvious
question.  
I have a table in Access that was imported from excel.  I am going to be
receiving this xls report on a monthly basis.  The excel reports has a BD tab

I am trying to write a code that allows me to add all
worksheet names into an array.
My array is defined as:
Dim SheetName (20) as String

I want to be able to build a text file putting the values in a form into a
letter that can be copied and e-mailed to clients.
Does anyone know the VB code for saving a string as a plain text file
(including specifiying the location etc)?

Hi to all, I want to programatically automate an odbc
connection to an externat SQL server, I would like to
know where I can find some good learning documentation (
tried ms knowledge base but too complex for me, my