SQL

[woofnews]

I'm new to Access (2000). I'd like to 1) be able to manipulate Access
tables directly from SQL, and, more importantly, 2) use pre-existing
Access databases to create MySQL and PostgreSQL databases without the
use of translation software. How do I gain direct access to the SQL
files?

[Benny Andersen]

On 25 Mar 2006 22:10:05 -0800, woofnews wrote:

I'm new to Access (2000). I'd like to 1) be able to manipulate Access
tables directly from SQL, and, more importantly, 2) use pre-existing
Access databases to create MySQL and PostgreSQL databases without the
use of translation software. How do I gain direct access to the SQL
files?

There is nothing called 'the SQL files' in access or any real database like
MySQL or PostgreSQL. SQL is a definition, manipulation and reporting
language.
Do you mean a SQL dump of the content of some database, like it is possible
in MySQL?
There is no built in feature in access to make a sql dump, but the fact
that vba is host language, makes it possible for the skilled programmer to
hack such a program together.
It is possible to export tables in acces in various formats.
--
Regards
Benny Andersen

[woofnews]

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. This would be enough to
solve my problem for now.

[Benny Andersen]

On 25 Mar 2006 23:55:16 -0800, woofnews wrote:

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. Creat and view the tables ? That's the first tab in the database window! It
can't be such a simple question you are asking or what ?This would be enough to
solve my problem for now.

Can you be more specific (perhaps using example data)

--
Regards
Benny Andersen

[Bernard Peek]

In message <11*********************@v46g2000cwv.googlegroups. com>,
woofnews <wo******@gmail.com> writes

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. This would be enough to
solve my problem for now.

I don't see what you are trying to achieve. You can already manipulate
table data using SQL in queries. What more do you want to do?
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

[rkc]

woofnews wrote:

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. This would be enough to
solve my problem for now.

You can use sql to create tables from the sql view of the
query builder, but there is no sql view of the table design.
You have to write the sql yourself.

If you spend some time with Google there are utilities that
export the create table sql to text files. Most are written
for compatibility with MySQL.

[Bob Quintal]

"woofnews" <wo******@gmail.com> wrote in
news:11*********************@v46g2000cwv.googlegro ups.com:

Thanks, my mistake. I'm not a programmer, but I have designed
databases using SQL (in PostgreSQL and MySQL). I just now
discovered how to view and create queries with SQL in Access
2000. I would like to know whether and how I can do the same
with tables. This would be enough to solve my problem for now.

Yes. You open a new query, go to SQL view, type the SQL data
definition language statements and execute the statement.

The table design grid is easier and faster.It also provides space
for documenting your table and field definitions.
--
Bob Quintal

PA is y I've altered my email address.

[Randy Harris]

woofnews wrote:

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. This would be enough to
solve my problem for now.

Others have given you the answer. If you wish, there is a freebie
download for Access, called SQL ScratchPad, that makes working directly
in SQL a bit easier.

--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Les Desser]

In article <fV*******************@newssvr14.news.prodigy.com> , Randy
Harris <pl****@send.no.spam> Sun, 26 Mar 2006 16:01:15 writes

there is a freebie download for Access, called SQL ScratchPad, that
makes working directly in SQL a bit easier.

Do you have a link to that?

Thanks.
--
Les Desser
(The Reply-to address IS valid)

[corey lawson]

"woofnews" <wo******@gmail.com> wrote in news:1143359716.538513.34060
@v46g2000cwv.googlegroups.com:

Thanks, my mistake. I'm not a programmer, but I have designed databases
using SQL (in PostgreSQL and MySQL). I just now discovered how to view
and create queries with SQL in Access 2000. I would like to know
whether and how I can do the same with tables. This would be enough to
solve my problem for now.

For $100 or so, you can buy a couple of tools from Datanamic that will do
what you want. The first, ImporterAccess, will slurp in the tables from an
Access database and load it into DeZign. DeZign is an Entity-Relationship
diagrammer, and one of the things it can do is target a ER diagram at a
different database system than what the diagram was designed for, including
translations of datatypes, etc., from which it will generate a new script
full of CREATE TABLE sql statements.

I say it as a happy user, not a paid shill for the app.

Visio Enterprise can also do it, as well as ERWin, etc. But I think DeZign
+ ImporterAccess is the cheapest solution and will get the job done.

http://datanamic.com

I haven't researched into finding a module that will grok the CREATE TABLE
SQL for an Access table based on attributes retrievable from DAO
TableDef/Field information, INFORMATION_SCHEMA views, ALL_TABLES, etc.

Lucky for you both MySQL and PostGres support autoinc attribute for integer
fields...

[Randy Harris]

Les Desser wrote:

In article <fV*******************@newssvr14.news.prodigy.com> , Randy
Harris <pl****@send.no.spam> Sun, 26 Mar 2006 16:01:15 writes

there is a freebie download for Access, called SQL ScratchPad, that
makes working directly in SQL a bit easier.

Do you have a link to that?

Thanks.

I haven't done my homeowork on this. It looks as though the SQL
Scratchpad is not a freebie, but a free inclusion with the Access
Developers Handbook. The link below seems to have a link to download it,
but I didn't try it.

http://www.mcwtech.com/downloads.aspx
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Les Desser]

In article <Ad*******************@newssvr13.news.prodigy.com> , Randy
Harris <pl****@send.no.spam> Fri, 31 Mar 2006 23:48:48 writes

The link below seems to have a link to download it, but I didn't try
it.

http://www.mcwtech.com/downloads.aspx

Thanks - I will try it.
--
Les Desser
(The Reply-to address IS valid)