"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...