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

database development in london - importing data

Forum home » Delegate support and help forum » Microsoft Access Training and help » database development in london - Importing data

database development in london - Importing data

ResolvedVersion Standard

Dafni has attended:
Excel Advanced course
Access Advanced course
Word Advanced course

Importing data

How do you import data from a word document to an access table

RE: importing data

Hi Dafri,

Thanks for the question.

This can be done in two stages. Access will not recognise the standard formatting of a word file and so the word file must be saved as a text file. Once it is a text file, you can go into Access and go to the option File> "Get External Data" and navigate back to where you saved you newly created text file and press ok.

I do hope that helps, anything else please get back to me

Tracy

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.