You've never coded mush, Bill – It's always been elegantly crafted J
Cheers, Graham
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, 21 August 2018 08:13
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Importing txt files
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
My nothing-to-do-with-Access blog
---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: "Graham Mandeno" <graham@mandeno.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar