Hello,
Can anyone help with getting VBA code which will be able import data from BO into table in access?
I can’t find anything and the VBA code which i’m using for excel isn’t working right in MS Acccess.
Many thanks,
Paul
sigterm (BOB member since 2014-03-16)
1> Your BO release is completely obsolete
2> Don’t try to use Bo as an ETL Tool. it’s just reporting one 
. Sound like another gaz factory…
3> perhaps generating an excel file from Bo then link this one as table in access
bernard timbal 
(BOB member since 2003-05-26)
Thanks for your feedback.
No chance for different version… some people still using BOXI!
I rather ETL than let some people with limited knowledge to load anything to access (yes - no money for license to use any other DB)
I need schedule this that it’s automated and don’t want use excel due the amount of data which need be pulled…
sigterm (BOB member since 2014-03-16)
Take it via Excel?
If you’re over 65000 rows, create an export report (concatenate your columns so that they can be saved as a delimited or fixed width text file).