Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › How to I create and access a mysql table from MS ACCESS
New Posts  All Forums:Forum Nav:

How to I create and access a mysql table from MS ACCESS

post #1 of 10
Thread Starter 
I work with MS Access to do analysis of transportation data and i get .txt that are sometimes over 2GB, so i usually need to split them in different databases, and join in another through a query, but that is a rather slow process, i know that mysql doesnt have that issue, so i would like to know is hot to create a table in mysql workbench importing a txt, and link it to a access file.
I coulnt find a complete newb guide for it.
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
post #2 of 10
I'm about 90% sure its impossible.. frown.gif
My Rig
(14 items)
 
Ex-wife's Rig
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 4460 AsRock H81M-DG4 Sapphire Rx470 Platinum KVR 1600 16Gb 
Hard DriveHard DriveCoolingOS
2x Seagate 3Tb Samsung 850 EVO 120 Scythe Ninja 3 Rev.B Windows 10 Pro 
MonitorKeyboardPowerCase
Fujitsu Siemens A17-2A Logitech K280e SuperFlower SF-550K12XP Thermaltake Versa H25 
MouseAudio
Logitech G402 Sony MDR XD150 
CPUMotherboardGraphicsRAM
Athlon 750K 4.0Ghz AsRock FM2A75 Pro4+ Sapphire R9 270X Dual-X Kingston 2x4Gb 1600 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 EVO 120  Western Digital 320Gb LiteON DVD-RW CoolerMaster Hyper Z600 
OSMonitorKeyboardPower
Windows 7 Pro x64 Toshiba 32" FullHD TV Logitech FSP Hexa 550 
CaseMouse
DeLUX Logitech 
  hide details  
Reply
My Rig
(14 items)
 
Ex-wife's Rig
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 4460 AsRock H81M-DG4 Sapphire Rx470 Platinum KVR 1600 16Gb 
Hard DriveHard DriveCoolingOS
2x Seagate 3Tb Samsung 850 EVO 120 Scythe Ninja 3 Rev.B Windows 10 Pro 
MonitorKeyboardPowerCase
Fujitsu Siemens A17-2A Logitech K280e SuperFlower SF-550K12XP Thermaltake Versa H25 
MouseAudio
Logitech G402 Sony MDR XD150 
CPUMotherboardGraphicsRAM
Athlon 750K 4.0Ghz AsRock FM2A75 Pro4+ Sapphire R9 270X Dual-X Kingston 2x4Gb 1600 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 EVO 120  Western Digital 320Gb LiteON DVD-RW CoolerMaster Hyper Z600 
OSMonitorKeyboardPower
Windows 7 Pro x64 Toshiba 32" FullHD TV Logitech FSP Hexa 550 
CaseMouse
DeLUX Logitech 
  hide details  
Reply
post #3 of 10
Quote:
Originally Posted by ronnin426850 View Post

I'm about 90% sure its impossible.. frown.gif

My advice: Abandon Access while you still can. It's a dead end for what you're doing. Mixing database platforms is also a recipe for future migraines. I would advise exporting or transferring all of your Access databases to MySQL.
post #4 of 10
Thread Starter 
Yep, but Access is good here, because we do most of our work in group, and many people dont have the knowlegde to work with databases on that level, so with access its easy to create a file with queries and tables that anyone can use. I am that one thats interested in making a switch to make things faster and easier in the long run, but having to push that knowlegde to everyone in the office is next to impossibruu
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
post #5 of 10
Best way I see to do this is to program your own application.

I just can't understand what you exactly want to do.
The app should be able to read the whole .txt files, split what you need, store it in access but that's pretty much all I can say concidering I don't have more information.

EDIT: You could simply read the .txt file, depending on what type of data is inside, split/gather all important information and insert them inside an array.

Then you go throught that array and for each element in the array, insert into database table name array[x].
Edited by Abs.exe - 12/14/11 at 11:32am
post #6 of 10
Yes, tailoring your own DBMS is probably the best solution. However, it will cost you, either a lot of time or a lot of money.
My Rig
(14 items)
 
Ex-wife's Rig
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 4460 AsRock H81M-DG4 Sapphire Rx470 Platinum KVR 1600 16Gb 
Hard DriveHard DriveCoolingOS
2x Seagate 3Tb Samsung 850 EVO 120 Scythe Ninja 3 Rev.B Windows 10 Pro 
MonitorKeyboardPowerCase
Fujitsu Siemens A17-2A Logitech K280e SuperFlower SF-550K12XP Thermaltake Versa H25 
MouseAudio
Logitech G402 Sony MDR XD150 
CPUMotherboardGraphicsRAM
Athlon 750K 4.0Ghz AsRock FM2A75 Pro4+ Sapphire R9 270X Dual-X Kingston 2x4Gb 1600 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 EVO 120  Western Digital 320Gb LiteON DVD-RW CoolerMaster Hyper Z600 
OSMonitorKeyboardPower
Windows 7 Pro x64 Toshiba 32" FullHD TV Logitech FSP Hexa 550 
CaseMouse
DeLUX Logitech 
  hide details  
Reply
My Rig
(14 items)
 
Ex-wife's Rig
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 4460 AsRock H81M-DG4 Sapphire Rx470 Platinum KVR 1600 16Gb 
Hard DriveHard DriveCoolingOS
2x Seagate 3Tb Samsung 850 EVO 120 Scythe Ninja 3 Rev.B Windows 10 Pro 
MonitorKeyboardPowerCase
Fujitsu Siemens A17-2A Logitech K280e SuperFlower SF-550K12XP Thermaltake Versa H25 
MouseAudio
Logitech G402 Sony MDR XD150 
CPUMotherboardGraphicsRAM
Athlon 750K 4.0Ghz AsRock FM2A75 Pro4+ Sapphire R9 270X Dual-X Kingston 2x4Gb 1600 
Hard DriveHard DriveOptical DriveCooling
Samsung 850 EVO 120  Western Digital 320Gb LiteON DVD-RW CoolerMaster Hyper Z600 
OSMonitorKeyboardPower
Windows 7 Pro x64 Toshiba 32" FullHD TV Logitech FSP Hexa 550 
CaseMouse
DeLUX Logitech 
  hide details  
Reply
post #7 of 10
Well depending on what is stored in that .txt file and How it is stored (ie : if those are names and they all finish by this sign --> ; it would be pretty easy to trim all the ; and get those names in an array)
If those are formulas and random stuff, it could get messy very easily, that would indeed add extra time/ to your project.
post #8 of 10
Thread Starter 
http://www.washington.edu/itconnect/web/publishing/mysql-access-3.5.html
Quote:
This article demonstrates how to connect to a MySQL server and edit database records using Microsoft Access. It assumes that you have familiarity with MS Access and that you have already installed MySQL on the UW servers.
Quote:
Command line with the mysql client.

OR

You can use MySQL as a data source in access

Found these things, why you guys said it wont work
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
post #9 of 10
Thing is I'm not quite sure I understand what you want to do :-/
post #10 of 10
Thread Starter 
Ok i think i managed, i setup a mysql server, installed the odbc connector and created a table in mysql with my over 2gb txt, then i created a access that can access that table and do queries. Im doing a query right now, ill see if it works
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
Sovereign
(15 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Maximus V Gene HIS IceQ 7950 16gb Samsung  
Hard DriveCoolingOSMonitor
Samsung 840 120gb H80i Windows 7 x64 Benq XL2420T 
PowerCaseMouseMouse Pad
Seasonic 1000 Platinum TJ08e Mionix Naos 5000 Propus 380 
Audio
Creative ZxR 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming
Overclock.net › Forums › Software, Programming and Coding › Coding and Programming › How to I create and access a mysql table from MS ACCESS