Appending Data from a SCV file.

[Daniel]

I'm looking for the best method of appending data from a CSV file, ie, end of month financial statements, The problem is The name of the statement changes every month, So I cant create a standardised method, I need the ability to search for a file select it and then run it. Should i be looking at Common dialog API procedures. Any help or samples of this process would be fantastic.

Kind regards
Daniel

 

[Ernie]

You might get a better answer if you post this in
the "importing/exporting, linking" forum.

For a start read this post, it may answer your questions:

http://support.microsoft.com/newsgroups/default.aspx?
NewsGroup=microsoft.public.access.externaldata&SLCID=US&ICP
=GSS3&sd=OFFN&id=fh;EN-AU;newsgacc

-----Original Message-----
I'm looking for the best method of appending data from a

CSV file, ie, end of month financial statements, The
problem is The name of the statement changes every month,
So I cant create a standardised method, I need the ability
to search for a file select it and then run it. Should i
be looking at Common dialog API procedures. Any help or
samples of this process would be fantastic.

 

[Daniel]

Cheers Ernie

You might get a better answer if you post this in
the "importing/exporting, linking" forum.

For a start read this post, it may answer your questions:

http://support.microsoft.com/newsgroups/default.aspx?
NewsGroup=microsoft.public.access.externaldata&SLCID=US&ICP
=GSS3&sd=OFFN&id=fh;EN-AU;newsgacc


CSV file, ie, end of month financial statements, The
problem is The name of the statement changes every month,
So I cant create a standardised method, I need the ability
to search for a file select it and then run it. Should i
be looking at Common dialog API procedures. Any help or
samples of this process would be fantastic.