Vinita has attended:
Access Introduction course
Access Intermediate course
Importing information
Is there a way to import information directly from another database i.e SAP?
RE: Importing information
Hi Vinita
It is possible to import data from another database. Either create a new database and from the task pane choose Project using existing data. Access will take you to a Data link dialogue box that lets you choose the data source for your database.
If your Access database already exists try going to the File menu and choosing Get external data. This requires an ODBC connection to be setup that makes your source database accessible to Access.
I hope this helps - do let us know if you have any further questions.
Kind regards,
Andrew