S
szag via AccessMonster.com
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?