RE: Error in docmd.transferspread***?

Hello Tore,

I understand there are issues even when you try to import the table
directly via File->Get External data->Import. It seems there are enviorment
issue on this machine.

In order to narrow down the issue, I suggest that you try the following
steps:

1. Try to create a new Excel file, and add some simple fields/data to test
this new file

col1 col2
1 test
2 test1

2. Try to create a new ADP file with new a database on the SQL Server, and
try to import from the newly create Excel file

3. If possible, try on a different client machine with Access 2003
installed, and try to import the newly created Excel file.

4. If the issue still occurs, please try a different SQL Server as backend
and create a new database/adp to test.

Per your question, "restarting the database" I mean close and open the adp
file again.

If the issue occurs with new sql database/new simple Excel file, and it
does not occur on a different machine, it should be a problem on the client
machine. Based on my experience, I once saw similar issues with some
Anitviurs program running. You may troubleshoot the issue with a selective
startup. To do so:

1. Run the System Configuration Utility (msconfig.exe): Click Start->Run,
type "msconfig"(without quotation mark) in the open box, and click OK.

2. On the General tab, select "Selective Startup" and then deselect Load
Startup items, select the checks on other options.

3. On the Services tab, click Hide All Microsoft Services. Deselect all the
items left.

4. Click the Apply button.

5. Reboot your client computer to check if the issue occurs at this time.

If the issue occurs only with the specific database/sql server, it might be
some problem on this server/database, please use sql profiler to capture
the trace when you try to import the data, and send the result to me at
petery@xxxxxxxxxxxxxx Also, plesae grant the Windows user you log on the
client system admin role on SQL Server to isolate permission issues.

I look forward to your reply. Thank you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================


.