Hello, > I would like to ask help on importing MS Access tables(Containing > many records and queries) to SAPDB >
with m$ access on it's own you got no real chance of doing this in an automatic way. But you can of course use the many, many benefits of a graphical user interface. Creating the tables is somewhat hard. As long as you got no special software that is able to extract the table definitions. Populating tables - once you have created them - is easy. Link the sapdb tables via odbc into your access database and insert the data either by copy and paste or by a query. For the queries: Keep access open as well as sql studio or websql, where you should be logged in as the user owning the queries. Open the queries in access in sql mode. Copy the text to the clipboard. Paste it to your favorite sapdb tool. Prepend 'create view (your view name here) as ' to the query text. remove the trailing ; Apply other necessary changes (e.g. insert upper() where appropriate). Click on execute. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
