Importing data

[WAYNEB]

Can I import data from SAP into Access?

 

[Uncle Gizmo]

Extact from Link below::::

>>>TablePro Allows you to download data from SAP® tables and views to Microsoft® Access or Microsoft® Excel or simply to text file with click of a button. <<<<



http://www.winshuttle.com/index.htmlhttp://www.winshuttle.com/index.html

 

[Pat Hartman]

SAP uses a database to store data so as long as you have the correct ODBC driver, you can link to the tables and extract whatever data you need.

However, the SAP table structure is so strange that most DBA's will not allow direct access to the database. They insist that you use some tool to extract what you need and then import it into Access. They won't allow you to link directly to the tables.