importing data

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

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

Importing data

resolvedResolved · Low Priority · Version 2003

Jane has attended:
Access Introduction course

Importing data

How can I import data most easily from 10 differnet .csv text files ?

RE: importing data

Dear Jane

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

It would be intersting to know if you want the ten different text files that will be imported in ten diffrent tables or in one table only!!

Please let me know and also please provide an example so that I can be clear in asnwering your specific query.

Many thanks

Kindest Reagrds

Rajeev Rwaat

MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

RE: importing data

Hello Rajeev,
The course was fab and I have been using access ever since, I have managed to do everything I need so far and I imported all the CSV files into separate tables in one DB liek you showed me during the day. I have also managed to figure out how to do the outer joins between the linked tables and verify that the key data is present in each.
Looking forward to the Intermediate course soon !
Kind Regards, Jane Fraser

 

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:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips


Server loaded in 0.09 secs.