Has anyone had problems with report formatting when
exported to rich text files? Any helpful hints would be
appreciated. thank you

I am importing an Excel97 workshet into Access97 that has
approx 57000 records that is laid out in 24 fields on the
spread sheet. After importing into Access, I end up with
16383 records not the 57000 I am expecting. I guess it

Does anyone know how to import a binary file?  It appears
to be one long line of data, and the best I can figure out
is the length of each field, but I don't know how to tell
Access when a new record starts.  Any help would be

.. i guess.
well i have the following code in an access module:
To open a excell worksheet from access through Automation
dim HojaExcell as Excell.Worksheet

I want to display an email in Outlook and export to an
Access database without having to use cut and paste. Can
this be automated? Would there be some VBA code to
accomplish this?

I am trying to export some data to Excel using the
Excel8.olb.  I am finding that on some PC's an error
occures.  I am sure it has to do with the version of Excel
they may or may not have, is there something simple I can

Is there a possibility to automatically import directly into the access
database? Using the a commandfile in Windows for starting the import without
manually opening Access. The data will be data from an Oracle database and
the import should be done every 4 hour . Exporting from the ...

My database tracks water consumption so service dates can
be forecast.  Each location has a certain size water
filter that has a specific useful life with the quality
of water.

thanks for reading!
Is there any way to send a report to multiple recipients
through Lotus Notes?  My company uses Lotus only, if it's
not possible - can anyone suggest a work around?

How do I reference the Sheets(Index) in a VBA  
Docmd.Transferspreadsheet command?  Thanks.

I am currently opening a series of DAT files in Excel
before importing into Access. Is there any way to import
directly into Access
Thanks

I would like to use Access as a front end to enter an
address or location (in code) to Microsoft streets &
trips or another map program & have that program return
the latitude & longitude of the address to Access. Is

From Access 2000 I am able to programmatically add a label
to an excel sheet using the following:
Set myLabel = myDocument.Shapes.AddFormControl(xlLabel,
100, 150, 200, 50)

    Hello, peeps!  Does anyone else bump into these when importing Excel into Access
* If the first few dozen or so rows have numeric data, Access imports it as numeric, even if importing to a Text field, and instructed to import data as Text, not General.  Ex: zip codes in ...

I want to use VBA to automate the import of fixed width
files (docmd.TransferText), but the file that will be
imported will always be changed.  How do I allow the user
the flexibility to chose which file that should be