Database to array

[lembi2001]

Hi All

I am wondering if it is possible to extract fields from a database table into an mmf array. I have had a look at ODBC but i have zero clue on how to use it.

The database itself is password protected and i only need specific columns out of it.

Anyone know if this is possible using the standard version of MMF2?

[Richard_Pikk]

What you are asking is possible, depending on the type of database. What kind of database do you need to access? The SQL Server object should work with MMF2 Standard, but it is for Microsft SQL Server databases only.

[lembi2001]

it's a standard MS Access Database. it's in an older file format but i can convert it to 97-2003 format.

I'm not sure how to use ODBC so i can't get anywhere with this at the minute.

[Lemon_Blizzard]

lembi2001
I think you may need the password in order to extract data.
Also, do you have any experience using SQL code?
e.g. select * from table_name
If not http://www.w3schools.com/sql/default.asp is a great site to learn from.
Also, have you looked at the ODBC example program which comes with MMF2? It shows a neat way of retrieving information using list objects.
Whenever you retrieve from the ODBC object you need the following actions:
New statement
Send SQL command
Get Row
The rest then depends on whether you are retrieving a unique entry or several rows.