UtterAccess.com
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    
 
   
arun.ms0910
post Sep 8 2019, 10:21 PM
Post#1



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
 
isladogs
post Sep 9 2019, 12:27 AM
Post#2


UtterAccess VIP
Posts: 1,806
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
 
Debaser
post Sep 9 2019, 03:34 AM
Post#3



Posts: 150
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    16th November 2019 - 07:36 PM