ms-access

55 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.

Solved September 21, 2009

Importing MS ACCESS DB to mySql?

I'm working on a project atm, and I need to import data that is stored in a MS ACCESS database to mySql. For mySql…

thumb_up 7 trending_up 4

Solved July 30, 2009

I have a report that tracks how long certain items have been in the database, and does so by tracking it over a series…

thumb_up 9 trending_up 3

Solved July 15, 2009

I'm experimenting with the Entity Framework and I want to connect to an Access 2007 database. The following code is inspired by…

thumb_up 13 trending_up 5

Solved June 26, 2009

Is there a library for using MS Access database in python? The win32 module is not as easy as the MySQL library. Is there…

thumb_up 24 trending_up 17

Solved May 15, 2009

I am a programmer, and my father uses Access to collect the patients information (my father is a doctor), He wants me to teach…

thumb_up 21 trending_up 6

Solved May 12, 2009

How can I access Microsoft Access databases in Python? With SQL? I'd prefere a solution that works with Linux, but I could also settle…

thumb_up 25 trending_up 24

Solved April 30, 2009

I want to do something like this within an MS Access query, but SUBSTRING is an undefined function. SELECT DISTINCT SUBSTRING(LastName, 1, 1) FROM…

thumb_up 26 trending_up 19

Solved April 29, 2009

What's the equivalent of an MS-Access crosstab query in TSQL? And Is there a better way? I have a data organised like this: Fish…

thumb_up 9 trending_up 4

Solved April 23, 2009

As part of my university coursework, I was asked to design and create an HCI for a shop. Part of it is to connect…

thumb_up 11 trending_up 1

Solved March 16, 2009

Can anyone explain to me what is wrong with my query? SELECT T2.TIPOPRODUTO , T2.PRODUTO , T1.ESPESSURA , '' AS LARGURA , '' AS…

thumb_up 8 trending_up 4