Excel database to SQL

Question

Hello,

I have very good excel database on network drive, and have programmed preaty much on in it, saving files on network drive, making pdfs, all within VBA.

I want to make database accessable on internet, for future applications, deskotop or mobile.

What is the best option to do that, having accessable database on internet? Thank you in advance

Answer 1

Hi there,
You may find what you are looking in those pages.

Libraries based on Python:
http://xlsxwriter.readthedocs.io/alternatives.html
https://www.xlwings.org/ (this one may grab your attention as it intends to replace VBA with Python)

Library based on PHP:
https://phpexcel.codeplex.com/