Thread: Import .csv file direct from web
02-02-06, 07:21 #1Registered User
- Join Date
- Jul 2004
Unanswered: Import .csv file direct from web
I'm writing a database to manage my Lotto numbers!
The UK National Lottery website allows you to download a complete draw history in .csv format. I've manually downloaded this and imported it into Access.
Can anyone advise me how I could automatically do this within Access?
If I can't import the file directly into a table, could I force the download to a temporary folder, and then import from there?
Also, could anyone advise me how to omit certain rows when importing from .csv as the file has a couple of rows after the header with non csv data, and this screws-up the import?
02-02-06, 19:17 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
get it into access is easy just Write a macro to import it
http://www.mvps.org/access/modules/mdl0037.htmhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON