Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing from various sources
0 views
Skip to first unread message
szag via AccessMonster.com
Dec 7, 2009, 8:09:29 PM12/7/09
to
Looking for some ideas on an application that I need to build. Basically I
have to go online to various sources and download banking/investment type
information - then push it into access. As you would expect each account is
in a different format (sometimes quite ugly). My thought is to download (or
in several cases simply cut and paste into excel, then write macros that
clean up the data in excel so it can be imported into access. Any thoughts
on if there is a cleaner way of doing this? Anybody have experiences doing
this sort of thing and have a process they used?
have to go online to various sources and download banking/investment type
information - then push it into access. As you would expect each account is
in a different format (sometimes quite ugly). My thought is to download (or
in several cases simply cut and paste into excel, then write macros that
clean up the data in excel so it can be imported into access. Any thoughts
on if there is a cleaner way of doing this? Anybody have experiences doing
this sort of thing and have a process they used?
--
Message posted via http://www.accessmonster.com
szag via AccessMonster.com
Dec 7, 2009, 8:09:39 PM12/7/09
to
szag via AccessMonster.com
Dec 7, 2009, 8:09:18 PM12/7/09
to
0 new messages