04-21-2005
Doesnt MS-Access have an export tool built in? If so use it to create a delimited file. Otherise you can write a VBA procedure to select all rows from a table and dump it into a delimited file on your PC. I dont know MySQL but am familiar with Oracles tools. Oracle has a utility called SQL*Loader that imports datasets from a flat file into the database. Look for something similar.
9 More Discussions You Might Find Interesting
1. Programming
help me in using database in c++
whether datas entered in c++ can be
stored in Oracle or access database?
give a hint (1 Reply)
Discussion started by: sajin_george
1 Replies
2. UNIX for Dummies Questions & Answers
I am looking for a database that i can use on Red Hat Linux 8.0. I wish to store records about my clients in it. I do not wish for i to be used on a server (3 Replies)
Discussion started by: adminbw
3 Replies
3. Shell Programming and Scripting
I have my main script calling another script to retrive a "ls -alt" of a directory that's located in a remote location I'm sftping into.
main.sh
#!/bin/ksh
getLS.sh > output.txt
getLS.sh
#!/bin/sh
/home<..>/sftp <host@ip> <<!
cd /some/dir/Log
ls -alt
quit
!
Basically I'd like to be... (2 Replies)
Discussion started by: yongho
2 Replies
4. Programming
THis is my program
#include <stdio.h>
#include "sqlext.h"
#include "sql.h"
#include <string.h>
#include<errno.h>
// #include "sqlunix.h"
#define STR_LEN 30
#define SQL_NTS (-3)
#define MYSQLSUCCESS(rc) ((rc==SQL_SUCCESS)||(rc==SQL_SUCCESS_WITH_INFO))
... (8 Replies)
Discussion started by: ramneek
8 Replies
5. Linux
Hai ,
can any one suggest me any site where the mysql tutor for linux is avialable i am new to the linux mysql so i want to know right from the basics and how can i connect those database to planner tool in linux
:)
Regards
Sanju (1 Reply)
Discussion started by: sanjustudy
1 Replies
6. Programming
how can we connect to database(psql) using c language?.
Any one help.Pls say the hader file and function's avilable in C for database operation(like connecting,selecting,etc...). (3 Replies)
Discussion started by: sabari
3 Replies
7. Solaris
hi..
i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database
which is in solaris 10 x86... can u tell me the procedure ..
how it can be done through php .. sorry am new to php...
is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies
8. Solaris
I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options.
OPERATION_TYPE = "createDatabase"
GDBNAME = "solaris_user.domain.com"
SID = "solaris_user"
TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies
9. Shell Programming and Scripting
I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies
LEARN ABOUT DEBIAN
sql::translator::parser::dbi
SQL::Translator::Parser::DBI(3pm) User Contributed Perl Documentation SQL::Translator::Parser::DBI(3pm)
NAME
SQL::Translator::Parser::DBI - "parser" for DBI handles
SYNOPSIS
use DBI;
use SQL::Translator;
my $dbh = DBI->connect('dsn', 'user', 'pass',
{
RaiseError => 1,
FetchHashKeyName => 'NAME_lc',
}
);
my $translator = SQL::Translator->new(
parser => 'DBI',
dbh => $dbh,
);
Or:
use SQL::Translator;
my $translator = SQL::Translator->new(
parser => 'DBI',
parser_args => {
dsn => 'dbi:mysql:FOO',
db_user => 'guest',
db_password => 'password',
}
);
DESCRIPTION
This parser accepts an open database handle (or the arguments to create one) and queries the database directly for the information.
The following are acceptable arguments:
o dbh
An open DBI database handle. NB: Be sure to create the database with the "FetchHashKeyName => 'NAME_lc'" option as all the DBI
parsers expect lowercased column names.
o dsn
The DSN to use for connecting to a database.
o db_user
The user name to use for connecting to a database.
o db_password
The password to use for connecting to a database.
There is no need to specify which type of database you are querying as this is determined automatically by inspecting
$dbh->{'Driver'}{'Name'}. If a parser exists for your database, it will be used automatically; if not, the code will fail automatically
(and you can write the parser and contribute it to the project!).
Currently parsers exist for the following databases:
o MySQL
o SQLite
o Sybase
o PostgreSQL (still experimental)
Most of these parsers are able to query the database directly for the structure rather than parsing a text file. For large schemas, this
is probably orders of magnitude faster than traditional parsing (which uses Parse::RecDescent, an amazing module but really quite slow).
Though no Oracle parser currently exists, it would be fairly easy to query an Oracle database directly by using DDL::Oracle to generate a
DDL for the schema and then using the normal Oracle parser on this. Perhaps future versions of SQL::Translator will include the ability to
query Oracle directly and skip the parsing of a text file, too.
AUTHOR
Ken Y. Clark <kclark@cpan.org>.
SEE ALSO
DBI, SQL::Translator.
perl v5.14.2 2012-05-01 SQL::Translator::Parser::DBI(3pm)