98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing information
Importing information
Resolved · Medium Priority · Version 2003
Wed 18 Feb 2009, 16:27Delegate Vinita said...
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?
Thu 12 Mar 2009, 09:45Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
