Appending Data from a SCV file.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ernie said:
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.
Click to expand...
 
Back
Top