98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Importing data
Importing data
Resolved · 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 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:Hiding Multiple Table columnsIf you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide. |