Importing

[skip]

Hi,
I need some help and even some guidenes to where I can find some
information. I have approximatley 250 files that were develped form a
program tha made the files into "csv" files. My supervisor wants me
to make an access database with these files. The fields will be most
of the titles from the csv files. What I need to do is to import these
csv files into the database. This will be a continuose project once
the data base has been established.
I really need to understand how to automatically import these files
when the need is there.
Can anyone help me.
Thanks,



Dan (Still going in circles)

 

[skip]

Thank you for getting back to me. My experience with Access is very
limited. I have played with it a few times, but that is about it. I
do not know VB and the only macro's I know how to do is to make a
recording of the procedure I want to repeat. As for the update and
append, I know the words, not the usage.
Thanks for all the help.

For a start:

File: Import: Get External Data: Text:

From there pick the file and then it should be comma delimited files
likely with first line the field name.

You will want to create an import/export specification. in the advanced
area

The first one you may make a new table. From then on you may? append a
table (It's been a while, for my own reasons I never used append).

That should give you some knowledge of one way to do it.

I made the assumption, that may be wrong, that you did not get that far
yet.

You also want to check out the help files for "Import"

Let us know a little more about your Access experience. Have you used
Macros? VBA? Update and append queries?

With that information we will be better able to make some suggestions.
I am sure someone has done this with a single click in an application and
may be willing to share their code and experience.

My experience never had data that was consistent from time to time to
fully automate it.

Good Luck

Dan (Still going in circles)