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]

Re: SQL

On 25 Mar 2006 22:10:05 -0800, woofnews wrote:
[color=blue]
> 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?[/color]

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]

Re: SQL

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]

Re: SQL

On 25 Mar 2006 23:55:16 -0800, woofnews wrote:
[color=blue]
> 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.[/color]
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 ?[color=blue]
>This would be enough to
> solve my problem for now.[/color]
Can you be more specific (perhaps using example data)

--
Regards
Benny Andersen

[Bernard Peek]

Re: SQL

In message <1143359716.538 513.34060@v46g2 000cwv.googlegr oups.com>,
woofnews <woofnews@gmail .com> writes[color=blue]
>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.[/color]

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]

Re: SQL

woofnews wrote:[color=blue]
> 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.[/color]

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]

Re: SQL

"woofnews" <woofnews@gmail .com> wrote in
news:1143359716 .538513.34060@v 46g2000cwv.goog legroups.com:
[color=blue]
> 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.
>
>[/color]
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]

Re: SQL

woofnews wrote:[color=blue]
> 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.
>[/color]

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]

Re: SQL

In article <fVyVf.42630$_S 7.37014@newssvr 14.news.prodigy .com>, Randy
Harris <please@send.no .spam> Sun, 26 Mar 2006 16:01:15 writes
[color=blue]
>there is a freebie download for Access, called SQL ScratchPad, that
>makes working directly in SQL a bit easier.[/color]

Do you have a link to that?

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

[corey lawson]

Re: SQL

"woofnews" <woofnews@gmail .com> wrote in news:1143359716 .538513.34060
@v46g2000cwv.go oglegroups.com:
[color=blue]
> 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.[/color]

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_SCH EMA views, ALL_TABLES, etc.

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

[Randy Harris]

Re: SQL

Les Desser wrote:[color=blue]
> In article <fVyVf.42630$_S 7.37014@newssvr 14.news.prodigy .com>, Randy
> Harris <please@send.no .spam> Sun, 26 Mar 2006 16:01:15 writes
>[color=green]
>> there is a freebie download for Access, called SQL ScratchPad, that
>> makes working directly in SQL a bit easier.[/color]
>
> Do you have a link to that?
>
> Thanks.[/color]

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]

Re: SQL

In article <AdjXf.61089$H7 1.28655@newssvr 13.news.prodigy .com>, Randy
Harris <please@send.no .spam> Fri, 31 Mar 2006 23:48:48 writes
[color=blue]
>The link below seems to have a link to download it, but I didn't try
>it.
>
>http://www.mcwtech.com/downloads.aspx[/color]

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