Importing

  • Thread starter Thread starter skip
  • Start date Start date
S

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 said:
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)
Click to expand...

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
 
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.
Click to expand...
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
Click to expand...



Dan (Still going in circles)
 
skip said:
On Sun, 09 May 2004 23:46:22 GMT, "Joseph Meehan"



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.
Click to expand...

Fry following the instructions I gave as a start. The words generally
represent menu options starting with the top line menu. Also press F1 and
then type in import or any other word that I may have used that does not
make sense to you and the help file should give you some ideas.

I suggest finding a book on Access. There are a lot of them, because
learning Access is not easy. Most people find it a difficult task to get
past first base. However it is a very useful product once you get the idea
of how it works.
 
Back
Top