X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Import Excel To Access Using Excel Vba Help Mee, Any Version    
post Sep 8 2019, 10:21 PM

Posts: 19
Joined: 19-June 19

Hi Frnds,

I have try to import excel data to access 1st time its running prperly but again run the code this error will show Run-Time Error 462: The remote server machine does not exist or is unavailable.".Please Help me... confused.gif
Go to the top of the page
post Sep 9 2019, 12:27 AM

UtterAccess VIP
Posts: 1,893
Joined: 4-June 18
From: Somerset, UK

First of all if you are trying to do this in Excel, you are exporting data to Access.

Instead I suggest you import the Excel data from Access. Try using the wizard in the External Data ribbon menu.

Colin (Mendip Data Systems)
Website, email
Go to the top of the page
post Sep 9 2019, 03:34 AM

Posts: 156
Joined: 11-October 18

As a general note, it's quite hard to troubleshoot code that you can't see... wink.gif

Typically though, that error means you have unqualified objects in your automation code and have therefore left something running that shouldn't be.
This post has been edited by Debaser: Sep 9 2019, 03:35 AM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    11th December 2019 - 12:53 PM