Well, I would do some operate in Python that will finish track of 100s of 1000's, maybe countless rows of information, each with records in maybe 50 or even more posts. I would like a method to keep an eye on this data and use it. Since I Have should also learn Microsoft Access, I would recommend putting the information inside. Can there be any good way to do that? I should also learn SAS, to ensure that could be fine too. Or, can there be another program/method I ought to know for this type of situation?
Thank you for any help!
Yes, you are able to speak with any ODBC database from Python, which will include Access. You will want the "home windows" version of Python (including things like ODBC) from ActiveState.
I'd become more concerned about the "countless rows" in Access, it may get a little slow on retrieval if you are really utilizing it for relational tasks (that's, JOINing different tables together).
I'd also have a look at the 50 column tables — sometimes you'll need 50 posts but more frequently this means you have not decomposed your computer data sufficiently to have it in normal form.
Finally, if you are using Python to read an Access database I'm not sure if I'd count that as "learning Access". Really learning Access could be while using front-end to produce and keep the database, creating forms and reviews in Access (which wouldn't be offered by Python) and programming in Visual Fundamental for Programs (VBA).
I like SQLite being an embedded database solution, especially from Python, and it is SQL dialect is most likely "purer" than Access's.
Since I Have should also learn Microsoft Access,
Drop the idea of learning Access.
I would recommend putting the information inside. Can there be any good way to do that?
Or, can there be another program/method I ought to know for this type of situation?