Re: [GENERAL] Import table from MS Access?
От | davidb@vectormath.com |
---|---|
Тема | Re: [GENERAL] Import table from MS Access? |
Дата | |
Msg-id | 00ad01bf56e0$aa6ce6f0$0602010a@bullwinkle.vectormath обсуждение исходный текст |
Список | pgsql-general |
We've had good luck with something we found at: http://www.sevainc.com/ David Boerwinkle -----Original Message----- From: Mike Mascari <mascarm@mascari.com> To: Chris Carbaugh <cjdesigns@sprintmail.com> Cc: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org> Date: Sunday, December 26, 1999 6:08 PM Subject: Re: [GENERAL] Import table from MS Access? >Chris Carbaugh wrote: > >> What is the best way to import a table from Microsoft Access 2000? >> >> I was able to export to a text file from access, but this was only the >> data. Can I export/import the table definition as well? >> >> I have been using pgaccess to administer my DB. It seems I can't tell >> it to import a comma delimited file? Is there any way around this? >> >> Any help is greatly appreciated. >> >> Chris >> > >One way is to use the PostgreSQL ODBC driver from Insight (search >yahoo.com for: postgres Insight ODBC), and use the File->Export function >in Access to export the tables to PostgreSQL. There are a few problems >with this method, though, if I recall correctly: > >1. Table and field names will be case-sensitive, so if you have a table >in Access called Employees with a field HireDate, then in PostgreSQL, >you must refer to this as "Employees"."HireDate", not employees.hiredate, >although you could programmatically rename the tables by performing an >update on pg_class and pg_attribute. > >2. Column constraints are not exported. If I recall (its been some time), >column constraints are not exported from Access when the tables are >created. And, unfortunately, there's no easy way to add them in >PostgreSQL using an ALTER TABLE statement. > >Nevertheless, it might be easier to perform the export in Access using >ODBC, pg_dump the database to a text file, perform whatever cleanup is >necessary, and then reimport. > >Also, I rember that there's a PostgreSQL upsizing tool somewhere that >does all this stuff for you. But for the life of me I can't remember >where... > >Hope that helps, > >Mike Mascari > > > >************ >
В списке pgsql-general по дате отправления: