Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 06-04-2019, 02:51 AM   #1
frankt68
Newly Registered User
 
Join Date: Mar 2012
Posts: 50
Thanks: 14
Thanked 0 Times in 0 Posts
frankt68 is on a distinguished road
How to import data from an excel file stored on a website?

Hi!


I'd like to know if it is possible to import data to access as a linked table from an excel file, stored on a webpage (not in Sharepoint)?
This is the link to the file:
https://www.jazmp.si/fileadmin/datot...nja_motnje.xls



When I try to import it, access gives an error, saying "Only XML files can be imported from an Internet address (http://, ftp://). Enter a path that points to a location on your computer or on the network"

frankt68 is offline   Reply With Quote
Old 06-04-2019, 04:27 AM   #2
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 5,558
Thanks: 55
Thanked 1,226 Times in 1,207 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: How to import data from an excel file stored on a website?

Hi. I think you may have to download it first. Once you have linked to it on your computer, you can download the latest copy and overwrite the old one.
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
Old 06-04-2019, 09:38 PM   #3
frankt68
Newly Registered User
 
Join Date: Mar 2012
Posts: 50
Thanks: 14
Thanked 0 Times in 0 Posts
frankt68 is on a distinguished road
Re: How to import data from an excel file stored on a website?

Thanks for the reply.

There is obviously no other way than a daily file downloading...

frankt68 is offline   Reply With Quote
Reply

Tags
excel , import , webpage

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from excel file gstylianou General 16 11-29-2018 05:50 AM
Connecting Access Database to website to import data automatically alfredo245 General 1 06-30-2015 09:57 PM
Import data from website krabople Modules & VBA 7 08-25-2014 08:56 AM
Command button to clear existing table and import new data from excel file jakobal Modules & VBA 8 01-11-2012 02:29 PM
import data from excel file starting from 5th row hotmalepiyush Tables 1 06-09-2008 05:55 AM




All times are GMT -8. The time now is 12:58 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World