-2

I've tried many options that people suggested here in the past, but none of them work.

I have Office 64-bit, I downloaded the Access Microsoft 64, followed the steps in QGIS but, when I try to open the .mbd, an error message appears: source not valid.

How can I solve this? Any other magic recipe?

3
  • What are you trying to do, add a table from an Access database or something else? See gis.stackexchange.com/questions/380492/… for adding a table.
    – johns
    Jun 23 at 12:44
  • Try to open with Office Bicycle database mentioned in my answer and, afterward, try to export it as CSV before opening it in QGIS.
    – xunilk
    Jun 23 at 15:16
  • I found out a workaround in W7. Please, see my Editing Note.
    – xunilk
    Jun 23 at 16:24

1 Answer 1

0

This file database type is also known as JET / MS Access database. As Linux user I'm not capable to use MS Access but mdbtools for converting them in CSV files that you easily open with QGIS. If you have issues with your Office software you can use an online converter as this for corroboration purpose. It can be found mdbtools for Windows in https://github.com/lsgunth/mdbtools-win.

First of all, I need a confident source of a mdb file. I used this one. I also need a tutorial for processing them.

After downloading it, I ran following command in Bash Console:

mdb-tables RollingThunder2003.mdb

As follows, it can be observed several sub databases included in RollingThunder2003.mdb. I only select Bicycle for converting it in CSV.

Bicycle BikeParts BikeTubes ChartOfAccounts City CommonSizes ComponentName Customer CustomerSize CustomerTransaction Employee GeneralLedgerTransactions GeneralLedgerTransactionsPosting GroupComponents Groupo LetterStyle Manufacturer ManufacturerTransaction ModelSize ModelType Paint Places2000 Preference PurchaseItem PurchaseOrder RetailStore RevisionHistory SampleCustomer SampleStreet StateTaxRate TempDateMade TubeMaterial WorkArea BicycleTubeUsage Component SampleName

For converting Bicycle in CSV, I used following command:

mdb-export RollingThunder2003.mdb Bicycle > Bicycle.csv

Afterward, I loaded CVS in QGIS (Data Source Manager, Delimited Text) as follows (no geometry option selected):

enter image description here

Result was obtained as in following picture. It can be observed that in the table there are 31823 records. CSV file can be perfectly open in QGIS.

enter image description here

Editing Note:

I exported mdb file to W7 in my PC and opened Bicycle database with Excel.

enter image description here

Opened database was exported with CSV option.

enter image description here

As exported CSV has semicolons (;) as delimiters, I load it in Windows QGIS as follows:

enter image description here

Result was obtained as expected.

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.