Though your description is very brief, I think you need a macro that
will do the work for you. Create a macro, then use the 'Transfer
Database' function. Also make a form with three text boxes. One text
box is to type the location of your database to export to or from. The
second text box is to type the name of the table you wish to export.
The Third box is on the form is to type in the name of the destination
table (what you want to call the table). Then in your macro, in the
'DatabaseName' slot, put without the quotes:
"=[Forms]![FormName]![Text1]". In the 'Source' box, put the name of
the table you wish to export or import. or use the second text box by
typing in this: "=Forms!FormName!Text2". Destination is what you want
to call the table or object on the remote side. Type in a value or use
the thrid text box by typeing in: "=forms!formname!text3". Then
attatch it to a button on the form and set your warnings to No. You're
off. you can use this with linking tables too and make your own table
linker. The one ms access provides is pretty lame and you have to
enter the destination for every table which gets annoying. Let me know
if this is what you meant.
Are you talking about importing and exporting database objects, for
database design?
Or about importing and exporting physical products from overseas?
I doubt that there is a template that specific. You can search for
Inventory templates on google - there are many - and add your own
customization to handle the specific issues of import and export; or
hire a developer to build it for you.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
