How to Use vbScript to Open and Work with Data in Access accdb Files - Late Binding Example

[@miles6875]

Sean, so this is the awesomeness you were referring to on your discord. Thank you!

[@seanmackenziedataengineering]

Yes, it is a pretty cool technique - if you work with Windows, you can do just about anything, on any version because vbScript is supported everywhere!

[@xavierbatlle1828]

Very interesting and useful for sheduled tasks! 😉

[@seanmackenziedataengineering]

Glad you think so!

[@bumpersmith]

Definitely would like to see some more extensive vbScript working with Access. An example might be setting up a new specified directory and copying a downloaded FE and BE database into the newly created directory. Then relinking the FE to the BE Like I said before, GOOD topics for Access on this channel.

[@seanmackenziedataengineering]

Thanks - I'll do some more on this topic!

[@asus12351]

WHAAAAAAATT!!!! I wish I had known about this sooner man that is cool Brewster !

[@seanmackenziedataengineering]

lol! nice 👍

[@srinivasavaradhan2312]

This is such an excellent video , Thanks Sean

[@seanmackenziedataengineering]

My pleasure!

[@DataisKing]

I wonder if VBScript can be used for Power BI?

[@seanmackenziedataengineering]

For programming languages, I think only Python and R are supported in Power BI. M and DAX are supported for query/data transformation purposes. However, you can do a great deal of data prep in vbScript outside of PBI before the data is consumed; for example, updating a table with new figures just before PBI auto-refreshes the published version of a report.

[@jerzykepinski]

Fantastic!

[@seanmackenziedataengineering]

Many thanks!

[@brockmartin7316]

This is great, I am interested in the scheduling part you mention. Is this the windows task scheduler or an access based scheduler?

[@seanmackenziedataengineering]

For sure, the Windows scheduler will do the best job. I found that the best way is to call the vbs script file in the scheduler using a .bat or .cmd (or powershell) file. Not always necessary, but sometimes helps. Just a single line with the name of the script in it. I'll add that to my upcoming videos!

[@SHCSBaker]

Good stuff!!! Could vbScript be used to check for updated FE?

[@seanmackenziedataengineering]

Absolutely! And to update it with a file from the network or FTP if necessary

[@hassanrozh6579]

Really it is cool, thanks so much.

[@seanmackenziedataengineering]

Glad you like it!

[@xavierbatlle1828]

Unfortunately vbs has been deprecated.

[@seanmackenziedataengineering]

Thanks for sharing! What do you think about that?

[@xavierbatlle1828]

@@seanmackenziedataengineering To tell you the truth, I use vbscript and powershell and it's not a big issue vbscript deprecation. Furthermore we can use it for years before it dissapears.