J
Jason Spence
I have several excel documents that come in each day with
orders on them (headers all stay the same) I in turn want
to place all the data into an Access Database. In a
perfect world I would like to have a button or something
that I can click and an import (macro or similar) will
run on all the excel files in a paticular folder. In a
similar perfect world I would like the import/access to
tell me if certain vital fields are blank before/after
importing.
I have very little understanding of visual basic, so I
need some help here.
Jason
orders on them (headers all stay the same) I in turn want
to place all the data into an Access Database. In a
perfect world I would like to have a button or something
that I can click and an import (macro or similar) will
run on all the excel files in a paticular folder. In a
similar perfect world I would like the import/access to
tell me if certain vital fields are blank before/after
importing.
I have very little understanding of visual basic, so I
need some help here.
Jason