template wizard

sivart · Feb 28th, 2002, 09:42 AM

Hi.
i've used the Template Wizard to create and link my workbook to a database, but i don't know how to transfer my data from my template to the database. I've read the help file but it just vaguely says that i have to save the template, but this does nothing to the database. could you tell me how to do this on excel 2000 and 2002?? cos i'm working on a project both at home and at college. On 2000 i've loaded up the Invoice template you get with it, and it has this macro on it that brings up the dialog box that i need for the transfer. how do i get this up?? I can't view the macro for some reason!!!!
thanks in advance
sivart

sivart · Feb 28th, 2002, 10:25 AM

anyone??

lenze · Feb 28th, 2002, 10:55 AM

See this article from Microsoft

http://support.microsoft.com/search/preview.aspx?scid=/search/viewDoc.aspx?docID=KC.Q214246%26dialogID=9960929%26iterationID=1%26sessionID=anonymous|8798890%26url=kb;en-us;Q214246

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 09:42 AM	#1
sivart New Member Join Date: Feb 2002 Posts: 2	Hi. i've used the Template Wizard to create and link my workbook to a database, but i don't know how to transfer my data from my template to the database. I've read the help file but it just vaguely says that i have to save the template, but this does nothing to the database. could you tell me how to do this on excel 2000 and 2002?? cos i'm working on a project both at home and at college. On 2000 i've loaded up the Invoice template you get with it, and it has this macro on it that brings up the dialog box that i need for the transfer. how do i get this up?? I can't view the macro for some reason!!!! thanks in advance sivart

Feb 28th, 2002, 10:25 AM	#2
sivart New Member Join Date: Feb 2002 Posts: 2	anyone??

Feb 28th, 2002, 10:55 AM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	See this article from Microsoft http://support.microsoft.com/search/preview.aspx?scid=/search/viewDoc.aspx?docID=KC.Q214246%26dialogID=9960929%26iterationID=1%26sessionID=anonymous\|8798890%26url=kb;en-us;Q214246