Importing data from Website - Newbie

[jienx83]

Hello all,

I know there are many similar post that sound like this. But its just that i cant figure out the simplest why to do it.
1. the website http://www.theocc.com/webapps/flex-reports
2. data from the website needed to be downloaded into excell

the catch
1. the report is not auto generated. user will need to pick the date from pull down box

if i try normal data import from many guides, it seems that the excel can not pull it, saying it is invalid. Please help me.

 

[Ian]

I've moved this thread to programming, as I think you'll need to use some VB script to get this working .

 

[jienx83]

thanx ian! sorry for the wrong dept!

 

[jienx83]

anything guys? please help me.

 

[jienx83]

bump

 

[jienx83]

so many wiz, none available to help?

is this method do-able?

 

[EvanDavis]

so many wiz, none available to help?

is this method do-able?

Yes it is possible, but obviously nobody here knows how, but be patient, you never know

 

[jienx83]

thanx Evan. from the amount of time taken, till today, i think this gonna need some pretty nasty coding.

 

[EvanDavis]

thanx Evan. from the amount of time taken, till today, i think this gonna need some pretty nasty coding.

Wouldn't say nasty coding, not sure how your site is done, is the info been pulled from sql servers ?

 

[jienx83]

the thing is that i want to pull daily report from the website and import it into excell. its a redundant job for me to go in the website interface everyday to input the criteria and to be able to obtain the data. i think it is a SQL server. im not quite familiar with the jargon. i hv been trying to do some basic import data from website that is available in the excel, but the outcome is very disapointing - not to be able to publish the data in excel.

 

[jienx83]

bump.

 

[jienx83]

bump again. hello anyone?

 

[EvanDavis]

bump again. hello anyone?

I'd say after several bumps and nobody replying, pretty much means nobody knows a solution, I have looked all over the net, but don't have a clue sorry

 

[jienx83]

i guess im just out of luck. thanx Evan.