Hi, my problem is this: I placed the import query via this web site http://data.nowgoal.com/1x2/index.htm. Now the problem that presents itself to me is that imports all the data except that the "TIME" field. I believe there is a need for a macro in vba...
Thanks for your patience!
Last edited by fragovic; 10-14-2013 at 07:22 AM.
Yes you are correct. When importing data from website, the date column is blank. I have no idea what's wrong with it. Probably the issue is within the website itself.
Simply copy and paste the data in excel sheet does the trick, then it contains the dates as well. Have you tried that?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hello, copying and pasting the date because I do not need the data to be updated ,thanks.Originally Posted by sktneer
Does anyone have the solution, the macro to import all the data?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks