mattdrinks
Technical User
I am trying to write a Import Wizard to import Text and Excel files in to Access. I would like to use the ImexGrid that Access's Spreadsheet Import Wizard uses.
I have started a new moudle and added a reference to accwiz.dll this shows two objects in the object browser FieldList and ImexGrid. But I am unsure on how to add an instance of these to a form.
I have searched everywhere and found some information on Microsoft's Web Site about getting the Wizard's forms and modules viewable in the project explorer, I managed this but none of the forms would open. I then managed to lose this and now can seem to acheive the same thing again. I did not bookmark the article it and now I can't find it!
Does anyone know how I can get an ImexGrid onto a form or even if you can customize the file import wizard to create a new wizard?
Any help would be great I have spent hours and hours searching the web but found very little, although this sites search engine is not working pefectly at the moment so if I have missed something I apologise and can you point me in the right direction.
Thanks
Matt
I have started a new moudle and added a reference to accwiz.dll this shows two objects in the object browser FieldList and ImexGrid. But I am unsure on how to add an instance of these to a form.
I have searched everywhere and found some information on Microsoft's Web Site about getting the Wizard's forms and modules viewable in the project explorer, I managed this but none of the forms would open. I then managed to lose this and now can seem to acheive the same thing again. I did not bookmark the article it and now I can't find it!
Does anyone know how I can get an ImexGrid onto a form or even if you can customize the file import wizard to create a new wizard?
Any help would be great I have spent hours and hours searching the web but found very little, although this sites search engine is not working pefectly at the moment so if I have missed something I apologise and can you point me in the right direction.
Thanks
Matt