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

importing data

ResolvedVersion 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.