Hi David,
as for controlling the wizard dialog boxes, you cannot do that ... but you can use the specifications you can create there.The tables that store import/export specs are:
MsysIMEXspecs
MsysIMEXcolumns
While you cannot modify the tables directly, you can use APPEND queries to add records to those tables -- and you can delete records from them directly. You can probably use UPDATE queries on them too, but what I usually do is
1. make-table from the columns of a spec using MsysIMEXcolumns
2. delete rows from MsysIMEXcolumns for a particular spec
3. modify specs
4. use APPEND query to write records back to MsysIMEXcolumns for a particular spec
---
> "the temporary table has the same field names as the columns in the Excel sheet"
I think they need to be in the same order too -- you can use a query to do that if you don't want to change the table.
have an awesome day,
crystal
Is there a way to view the import wizards background code so I can program a command button to perform the same steps the wizard is performing?
I am importing an Excel file with a single worksheet into the same temporary table each time. the temporary table has the same field names as the columns in the Excel sheet.
I have some code from a Programming by Example book, but I cannot get it to work.
Thank you, David
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar