Lensmeister
Registered User.
- Local time
- Today, 02:10
- Joined
- Feb 18, 2009
- Messages
- 65
Hoping someone can help me out here.
I have searched a bit and I have some answers but I need a little clarity if possible.
I have a Access 2003 DB and in it I have a table called tbl_NFM
In the same directory on our network I will bve having various csv files that I wish to import in to the table (tbl_NFM) singleally.
e.g.
1st I will import NFM05a and once it's been viewed I wish to import NFM06 and view it.
What I need help on is
1) I want to be able to allow the user to chose what csv file to open, how should I do that (like a dialogue box?)
2) When I import NFM06 I want it to overwrite all the data in the table (tbl_NFM).
3) If it doesn't overwrite is there a way that before the new csv is imported it deletes all the records in the table (Tbl_NFM)?
4) I will need to automate all this, so I suspect a macro from a command button would be best to open the dialogue, choose the file name and then import it?
Thanks for the help all.
Lensmeister.
I have searched a bit and I have some answers but I need a little clarity if possible.
I have a Access 2003 DB and in it I have a table called tbl_NFM
In the same directory on our network I will bve having various csv files that I wish to import in to the table (tbl_NFM) singleally.
e.g.
1st I will import NFM05a and once it's been viewed I wish to import NFM06 and view it.
What I need help on is
1) I want to be able to allow the user to chose what csv file to open, how should I do that (like a dialogue box?)
2) When I import NFM06 I want it to overwrite all the data in the table (tbl_NFM).
3) If it doesn't overwrite is there a way that before the new csv is imported it deletes all the records in the table (Tbl_NFM)?
4) I will need to automate all this, so I suspect a macro from a command button would be best to open the dialogue, choose the file name and then import it?
Thanks for the help all.
Lensmeister.