I am running a stored procedure using a pass-through query.  This stored
procedure will update some summarized values in a table on SQL server and
will not return any recordset.  However, how do I know when it finishes
running and whether or not it runs successfully by using VBA ...

I use the following export code to export from access 2003 to a CSV file,
but after this I need to import the file to a website and the website only
accepts the seperator ; but what I try I always can the commaseparator (,)
Can someone please help me how to get an ; as separator.

When I try to import a spreadsheet into Access, I can not change the data
type. It is always "grayed out". How do I fix this?

I am trying to import a CVS file using following command
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"tblTempUpload", txt_box_file_path & strFileName
It gives me error.. Says external table is not in correct format.

Is there anyone that can please help me.
I need to be able to import a .csv file into a table, however the file will
have a different name each time and Access is telling me that it is required
to have the complete path and name of the file to be imported.

I have 2 computers.  Both have the same versions of MS OFFICE (and Access).
I have installed the FoxPro ODBC drivers on one (using the OWC.exe install
file from Microsoft).
But...when installing it on the other computer....it reports that it DOES

Damit! I try this update in a query and it randomly cuts off text!!
UPDATE Pathfindermerge SET Pathfindermerge.Street =
trim(InStr([Address]," ")-1);
sample field looks like this:

In the help information for Access 2K it states that for creating a macro
definition to import data you need to include the complete path statement.
My problem is different users are mapped differently to the location of the
datbase.

Is it possible to go into Access, use a form to enter data, and then export
only that record to Excel and add it to the bottom of an existing Excel
spreadshet?  I would like to do it with a macro if at all possible.  I don't
know programming at all.  

Dear gurus - Need your valuable help again,
I want to export data from one PC (MS-Access) and then import that data in
another PC.
I currently have a macro using the TransferDatabase (in a second mdb file -

Working with several .mdb databases, I've created links to a few .csv files
that are refreshed weekly and used by these databases.  Suddenly, upon
attempting to add additional links to any of the databases, Access no longer
allows me to do this.  Upon clicking import external ...

Need help importing *.dat files created from SQL Server 6.5 backup files into
Access 2003.

When importing a text file or an excel file that has international characters
such as é, the characters are displayed as gobbly-gook. If I export, I see
that Access has permanently changed them to gobbly-gook. I know there's a way
to fix this, I just don't know what it is. I'm on ...

I open an explorer window on a particular folder from access (using Shell
command or FollowHyperlink). I possibly need to rename the folder. My
problem is that Windows apparently prevents renaming the folder as it
appears to be locked or dependent from Access. Any suggestions as to ...

I have created an automated mailmerge using the following code, it is set up
to email the mailmerge, but  I can't figure out how to answer to the two
questions it is asking me.  First in word it asks, "Opening this document
will run the following SQL command: SELECT * FROM ...