I have user on 2002 trying to export from a access table
to excel.  When the save as window comes up she does not
have the excel file options in the drop down menu?  Any
ideas?

I'm trying to import two excel spreadsheets into Access 2000. All fields, in excel, are set to text, yet when I import them in access this one field appears as double. What's even more confusing is that of the two files, A and B, this only happens for one of them
The field ID ...

As subject describes, I'm trying to build an application
which will dynamically link to local oracle DB based on
username pwd and table name selected on a form.  I'm an
experienced Access developer but cannot seem to figure out

Okay, so I caved a split our database. But before I
decide if it's the way to go, I want to test it.
One thing that I haven't figured out yet is now that I've
split the database, what do I do to distribute the new

I am trying to import about 240M of text records into a DB
created in Access 2000, using Access 2002.  When I do I
get an error that says to the effect that I am out of Disk
space.  I have updated my MDACs and Jet 4.0 drivers but

I have a group of users, on different parts of the network, who open the
same MDB file residing on a common network drive.  Thus they have the same
collection of queries, on the same data, etc.
The remote MDB links to data in a MySql table.

I am posting this on both excel & access boards because I
am not sure where it should go, please forgive the
duplication.
I am using excel as a data input, multiple files, same

HEY THERE I AM TRYING TO FIGURE OUT HOW TO PREVENT SOMEONE
FROM ENTERING DATA TO MY SUBFORM WITHOUT THEM FIRST
PICKING A CATEGORY THAT THEY ARE GOING TO WANT THE
INFORMATION TO BE IN.  HOW DO I PREVENT THE POSSIBILITY OF

I am having trouble with my Access database.  I have a
Mail Merge form I am filling out on Word, and I need to
have a phone number field.  The problem is when I merge
the database and word file together the input mask I have

Trying to link to a DB2/400 table using IBM Client Access
Expess ODBC Driver.  Link is sucessfully created, but on
attempting to open the table I get an error indicating a
numeric value is out of range. (I get the same error

I am using the TransferSpreadsheet macro in MS Access to
replace data in a specific sheet in an MS Excel
workbook.  At first this was working very well.  Then it
began to create new sheets with a "1" at the end or gave

I need to call an Oracle 9i stored procedure from a MS
Access 97 or MS Access 2000 database. I could convert the
stored procedure to a function is this results in an
easier implementation.

Does anyone know if it's possible to import a single
record into the Outlook Calendar and have it go to a
specified date?

I have two similar queries which I am exporting (using
the DoCmd.TransferSpreadsheet function in VBA) to Excel.
The first one is:
SELECT Accounts.AccountNumber, Accounts.AccountName,

I do hope you can help as I don't know what to do about
the following.
I've done a database and was asked to provide exports of
data in a specified format for our Accounts system