Microsoft Visual Basic Run Time Error 80070057 on Importing Data to Excel

Asked By chrisstate 1030 points N/A Posted on - 06/26/2011

Hi all,

There are some new implementation to our company's database. We need to get some data from our old Excel files, so I decided to import some data from Microsoft Excel files so as not to encode it again.

When I was on the process of importing data from Microsoft Excel, I met an error that said," Cannot connect to the server at this time. Your table cannot be published".

Microsoft Visual Basic
Run-time error '-2147024809 (80070057)':
Cannot connect to the server at this time. Your table cannot be published.

I thought of a solution to this error. What came into my mind was the physical connection going to the server. But when I checked my connection, I am connected to the server. I am now wondering what else shall I check to get rid of the error.

Please help me with my problem.

Thanks.

• Status: Open
• Question Views: 3200
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by AikenAiken

Go To Solution

Best Answer

Best Answer

Answered By AikenAiken 0 points N/A #124564

Microsoft Visual Basic Run Time Error 80070057 on Importing Data to Excel

This problem can be solved by the following method.

• The problem is caused due to when the Windows is not updated.
• You may update your Windows to solve the problem.
• First of all click on the Start button and then right click on my computer.
• A drop down list will appear then select the Properties.
• When you select the properties then you saw a tab Automatic update.
• Click on this tab, after clicking then select the Automatic update box.
• Then computer ask the schedule for the Automatic update.
• Then you have to give the schedule.

The other way you may have to solve the problem is:

• Click on theStart button and select the Control Panel.
• Then open the Automatic update icon.
• The same windows will appear like when you click on the computer icon.
• You may have to done the same procedure I mentioned in above.

Thank you.

About AikenAiken

Questions
0

Answers
3

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 07/03/2011
• Question Category: MS Excel

Answered By shenna22 5 points N/A #124565

Microsoft Visual Basic Run Time Error 80070057 on Importing Data to Excel

Hi good day,

The causes of this kind of problem are the Registry might be corrupt,  attacking of virus likes malware, and outdated Windows driver.

• To fix this kind of issue, update your Windows driver and download Registry Repair software. This software will scan your registry and fix the error problem…
• Just visit this site for information of that issue.

Thank you. Hope this helps.

Regards,

 

Shenna22

About shenna22

Questions
0

Answers
71

Best Answers
26

• Vote Up 0 Vote Down

• Posted on - 08/02/2011
• Question Category: MS Excel