Your help is appreciated
-
sig too big -
i think so...why?
Proadultoutsourcing.com ~ version 2.0
OFFSHORE SOLUTIONS PROVIDER SINCE 2003
ACCOUNT EXECUTIVE
264-580-554 -
Because I have a SQL database that I'd like to convert to an Access databaseOriginally posted by LittleSassy
sig too bigComment
-
Another dumb question, why would you want to? Access is soooo limited.Comment
-
I know it's not like saving a JPG as a GIF, if that's what you're asking.
j/k
Can't you just dump the data from one and import it into another - tab delim, csv....?Your post count means nothing.Comment
-
Hi Lenny,
If you're talking about importing tables from SQL database into Ms Access, here is the simpliest way to do it.
Obtain an ODBC driver for your SQL database, install it then import the tables into Access using that driver.
It worked very well for me with MySQL
Good luck.Comment
-
Originally posted by MeorazharHi Lenny,
If you're talking about importing tables from SQL database into Ms Access, here is the simpliest way to do it.
Obtain an ODBC driver for your SQL database, install it then import the tables into Access using that driver.
It worked very well for me with MySQL
Good luck.
.Comment
-
SQL is a query language, you talking about MySQL?Comment
-
install a Mysql to Access engine/plugin
then from Access you can now import it
| offshore solutions | manual labor | staff leasing | and more!
Dedicated -Motivated-Managed Employees
icq.: 309570461 live chatComment
-
Export to .cvs and import into access
Work with PPC SE ( Umax, 3FN Marketing) and GET PAID FOR EVERY CLICK !!!
Next step after PPC - Pay Per Lead/Action
Good, filtered traffic: Chocker, Traffic Holder || My favourite hosting: HQ HostComment
-
Because I can have an Access database on my local machine, but I can't have a SQL or MySQL database on my desktop.Originally posted by ContentProducer
We're doing all of our cross referencing and indexing for 2257 compliance on a SQL database on my server..then we export it to a .csv file to keep locally.
I just thought it might be better to export it as an Access database so we could run queries and stuff like that locally.sig too bigComment
-
Download Navicat MYSQL. Its a remote MYSQL software for windows.
Just need to enter your unix server ip, user/pass for mysql.
You can export,import over 50 extentions direct in your MYSQL database
with 1 click.
Access, Dbase, XLS, XML, etc etc
I use this on a daily basis.
Hope it help.Comment
-
[QUOTE=Crypt]Download Navicat MYSQL. Its a remote MYSQL software for windows.
QUOTE]
what he said
Comment
-
good luck lenny!Comment
-
Originally posted by Lenny2
why can't you have MySQL on your local computer? of course you can have MySQL on a Windows machine - no prob at all. i must admit that Access is easier to handle when you are used to it - but for the rest....Comment
-
Yes, you can run Apache and MySQL locally.Originally posted by MaDaltonComment
Comment