I have a user who is receiving this error.
"The wizard is unable to access information in the file
C:\Documents and Settings\Jalpern\My Documents\ etc...
Please check that the file exists and is in the correct

I am trying to write a codes to auto export tables and data from SQL Server
2000 to Access2000 database.
by using:
docmd.TransferDatabase acImport, "SQL Server", ....

Would like to create db to track consultants, clients, meeting dates, etc...
Queries to create reports in any number of ways... total days, monthly days,
by clients, by consultant, etc....
Want the db to automatically input appointment into outlook calendar...

Please help me to export a Access Report to Excel (XP) if
someone know how to do it

hi.  i had a database in access 2002 that was fine.  then
i upgraded to access 2003, and now everytime i open that
database it asks me if i want to "block unsafe
expressions."  i downloaded the patch for jet 4.0 service

I have a need to export the data in one of my tables to another DB format where the field mapping is very manual and not one-to-one at all. How do I do this?

I have a access table with two columns FileName
(text) ,Picture(OLE Object). I need to load the photo
pointed by FileName into the Picture column dynamically.
Can anybody pls let me know how to do this ????

Hi, I am having issues exporting from MicroStrategy to Access XP.  The problem occurs when a " (double quote) is present in a record.  When this character occurs, everything following it is blank.  This was not the case in Access 97.  Is the double quote character reserved?  I am ...

I'm trying to import datea from a mainframe flat file into
several access tables.  I don't seem to be able to import
signed numeric data with assigned decimal places into the
access tables I created.  

I am having troubles importing an XML file.  The step by
step training  program asks you to import a file choosing
under 'files of type' xml file, but when I go to files of
type there is no option for xml.  I know the file exists

Can you export an Access Database into SQL? If you can how hard is it?

I want to import data from a website directly to access.
I know it's possible using excel (data/external datas/new query on
web) but I didn't find anything for Access.
I'd like to do that with no action with excel (web query and export or

Table includes 7 fields - each for one day of week Sunday through
Monday.
They are Yes/No fields.
Need to export the results of a query that includes those fields to a

Hi there.  I'm trying to import DOS characters with foreign accents (grave,
acute, circumflex, etc) into Text fields in a table in Access97 but Access
seems to be converting them along the way.  eg. an E with an accent acute
somehow gets imported as a comma.  How can I get Access to ...

I am receiving the following error when attempting to
import a Fixed-Width, large .txt file in Access:
"The search key was not found in any record"
I have performed hundreds of imports just like this with