Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » Importing Information

Importing Information

ResolvedVersion Standard

Thu 21 Feb 2008, 16:31 Delegate Shelley said...

Shelley has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Importing Information

Can you import information in different formats other than excel and access tables?

Fri 29 Feb 2008, 14:57 Trainer Carlos said...

RE: Importing Information

Hi Shelley

As long as the data being imported is in a table form Access will have no problems with it.

Access uses ODBC which can connect it to any database.

You can also import from Outlook (Contacts data), Lotus, Paradox, Text files, HTML and DBASE

Hope this helps

Carlos

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Importing Information

Importing Information

RE: Importing Information

Access articles

Access tip:

Create An Inaccessible Field On A Form