From time to time, we receive datasets from an external
organization in excel format.  We want to run a series of
validations and conversions on this data before we save it
as a "trusted" data table.

Does anyone know how to import XML files into Access
2000, as I can't find anyway that this is possible...
Cheers.

When I set up an ODBC Connection with SQL Server,how can I
get the password to be saved so that the user isn't
prompted every time they open the linked SQL table?

I have been exporting a query to Excel spreadsheet just
fine.  I have now added 4 additional columns.  Total
columns is now 14 with the same rows at 820.  I now get
the error "Too Many Fields Defined".  I can no longer

We have just installed Microsoft Office 2003 on top of
Office 2002.  I pulled up an Access routine and went to
relink my linked tables to another set of the same tables
on another server.  However, when I called up the linked

Looking at the automation objects exposed by the
Microsoft Access 10.0 Object Library, I see that the
ExportXML method is accessible at the Application object
level.  From this, I assume that I can only export the

I'm using  Access 2000 linking FoxPro Tables via ODBC
When I link tables with numeric fields Access gives me an error:
"The Decimal field's precision is too small to accept the numeric you
attempted to add."

I am getting the message when trying to run a macro
created on another machine.
"The format in which you are attempting to output the
current object in not available."

I have a database set up with a master copy, a front end
and a back end.
The master copy contains all of the info, and is then
exported to the front and back ends periodically.

I have a number of spreadsheets on a shared drive, all
with the same columns in the same format, but information
relating to different offices.
I have linked them all individually into my database to

Hi
I have an SQL database that I ame retrieving records from,
witrh an access ADP front-end. I am trying to write
recordset results to an excel spreadsheet. I need to to

I have an existing table that was setup for importing txt files to it.  I recently tried to import a txt file to it and now I am getting an error.  A "Type Conversion Failure on my Date/Time field.  The data in the import wizard shows as a date/time field and the field in the ...

Table has fields for both phone numbers and fax numbers.
They both use the Phone Number input mask.
When exporting to text, it is exported as a string of ten digits.
nnnnnnnnnn

When attempting to export data in a query and specifing
XML I get the following error message:
Microsoft Access was unable to export the data.

I am linking a CSV file (comma delimited text) with a
date field in "mmddyy" format.  What's the easiest way to
convert that to an ACCESS date format?
Thanks in advance.