Nigel
I put together a public function for you. It was a fun exercise. I don't get to code mush anymore. I put it in our Files>3_CodeSnippets folder.
It might need some work but it seems to do exactly what you asked for.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <nigel@pegasusconsulting.co.uk> wrote :
Hi all,
In a new application I'm working on I will need to import comma separated txt files on a monthly basis and append to a table.
Please can I ask for some pointers to the best methods for doing these things...
- checking that field headings in the txt file are in the same order as the destination table
- if not, can I import the data and have the code reorganise the data into the right destination fields, or do I need to give the user a warning so s/he can edit the txt file to reorganise the field order first?
- actually do the import - should I use the DoCmd method?
- append the source file name into a field in the table (against each imported record)
- append import date/time into the table (against each imported record)
Cheers
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
SPONSORED LINKS
.
__,_._,___
Tidak ada komentar:
Posting Komentar