|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
06-03-2005, 01:07 PM
|
#1 |
|
I'm Lenny2 Bitch
Join Date: Mar 2001
Location: On top of my soapbox
Posts: 13,449
|
Dumb question - can you convert a SQL database to access?
Your help is appreciated
__________________
sig too big |
|
|
|
06-03-2005, 01:10 PM
|
#2 |
|
Confirmed User
Join Date: May 2005
Location: behind you
Posts: 7,402
|
i think so...why?
__________________
 Proadultoutsourcing.com ~ version 2.0 OFFSHORE SOLUTIONS PROVIDER SINCE 2003 ACCOUNT EXECUTIVE  264-580-554 |
|
|
|
|
06-03-2005, 01:31 PM
|
#3 | |
|
I'm Lenny2 Bitch
Join Date: Mar 2001
Location: On top of my soapbox
Posts: 13,449
|
Quote:
__________________
sig too big |
|
|
|
|
|
06-03-2005, 01:33 PM
|
#4 |
|
Two fresh affiliate progs
Industry Role:
Join Date: Nov 2004
Location: Inside teen pussy
Posts: 29,602
|
Another dumb question, why would you want to? Access is soooo limited.
__________________
[email protected] Skype: 17026955414 Vacares Web Hosting - Protect Your Ass with Included Daily Backups |
|
|
|
|
06-03-2005, 01:37 PM
|
#5 |
|
Confirmed User
Join Date: Apr 2003
Location: Loveland, CO
Posts: 5,526
|
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. |
|
|
|
|
06-03-2005, 11:27 PM
|
#6 |
|
Confirmed User
Industry Role:
Join Date: May 2005
Location: ICQ: 5262689
Posts: 672
|
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. |
|
|
|
|
06-03-2005, 11:28 PM
|
#7 | |
|
Let slip the dogs of war.
Industry Role:
Join Date: Jan 2003
Location: Bermuda
Posts: 17,263
|
Quote:
__________________
. |
|
|
|
|
|
06-04-2005, 12:13 AM
|
#8 |
|
Too lazy to set a custom title
Join Date: Oct 2001
Location: Spartaaaaaaaaa
Posts: 14,136
|
SQL is a query language, you talking about MySQL?
|
|
|
|
|
06-04-2005, 08:01 AM
|
#9 |
|
Confirmed User
Join Date: Feb 2005
Location: Manila
Posts: 400
|
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 chat |
|
|
|
|
06-04-2005, 08:13 AM
|
#10 |
|
Confirmed User
Join Date: Aug 2004
Location: in your imagination...
Posts: 491
|
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 Host |
|
|
|
|
06-04-2005, 08:14 AM
|
#11 | |
|
I'm Lenny2 Bitch
Join Date: Mar 2001
Location: On top of my soapbox
Posts: 13,449
|
Quote:
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 big |
|
|
|
|
|
06-04-2005, 08:35 AM
|
#12 |
|
Confirmed User
Join Date: Apr 2004
Posts: 2,225
|
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. |
|
|
|
|
06-04-2005, 08:45 AM
|
#13 |
|
WINNING!
Industry Role:
Join Date: Oct 2002
Posts: 14,579
|
[QUOTE=Crypt]Download Navicat MYSQL. Its a remote MYSQL software for windows.
QUOTE] what he said |
|
|
|
|
06-04-2005, 09:00 AM
|
#14 |
|
The one and only!
Industry Role:
Join Date: Nov 2002
Location: Atlanta, GA
Posts: 17,761
|
good luck lenny!
__________________
Mandy's Playhouse Her First Fat Girl If you're interested in promoting my sites, ICQ me! 178411921 |
|
|
|
|
06-04-2005, 09:40 AM
|
#15 | |
|
I am Amazing Content!
Industry Role:
Join Date: Feb 2004
Posts: 39,829
|
Quote:
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....
__________________
AmazingContent.com - providing only the best content and service since 2003 Monetize your content on Veegaz.com - one of Germanies largest VOD sites Got German traffic? We convert it into money for you! Skype: madalton02826 - Email: oltecconsult [at] gmail [dot] com |
|
|
|
|
|
06-04-2005, 09:47 AM
|
#16 | |
|
Two fresh affiliate progs
Industry Role:
Join Date: Nov 2004
Location: Inside teen pussy
Posts: 29,602
|
Quote:
__________________
[email protected] Skype: 17026955414 Vacares Web Hosting - Protect Your Ass with Included Daily Backups |
|
|
|
|
