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

accessimporting data

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access-importing data

Access-importing data

ResolvedVersion 2007

Clare has attended:
Access Introduction course

Access-importing data

Can you import data from any other software apart from Word or Excel? For example Filemaker Pro?

RE: Access-importing data

Dear Clare

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

Please note that Access is a Database program and most of the database programs can import and export data from other databases and spreadsheets.

Sometimes when the databases or spreadsheets are not compatible with each other then most of the databses and spreadsheets program have the facility to convert the data into CSV (Comma Seperated Values) or tab limited.

Normally anything that is arranged in rows and columns can be imported into Access.

I am noty very familiar with the PageMaker program but may be the link below will help you in answering your query:

http://kb.adobe.com/selfservice/viewContent.do?externalId=330127

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Tue 3 Feb 2009: Automatically marked as resolved.

 

Training courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

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.11 secs.