Hi is it posible, to export data excel to access using vba code vilas chavan
On 7/19/10, Kishan Reddy, K <kishanreddy.kethire...@gmail.com> wrote: > Hello, > > Very simple. > > Select the macros tab. > > click on the new button. Macro window will appear. > > In actions column select 'TRANSFERSPREADSHEET'. > > In action arguments column - > specify transfer type, spreadsheet type, table name into which data to > be exchanged, excel file name with path, > if the excel sheet is having header row in first column - set Has > field names to yes. > If you want to import only specified range from excle then mention the > range. > > Just save it and name it accordingly. > > Then select the macro and say RUN. > > the macro will be executed. > > If you still have a problem, send me the excel file and access DB to > me. > > Regards, > > Kishan Reddy, K > kishanreddy.kethire...@gmail.com > > > > > > > > > On Jul 19, 10:20 am, debasish <debasis...@gmail.com> wrote: >> I am a novice in macro... could you please elaborate more on this.. >> >> Thanks & regards, >> Debasish >> >> On Jul 18, 8:40 pm, Kishan K <kishanreddy.kethire...@gmail.com> wrote: >> >> >> >> > Hi, >> >> > In access, try to create a MACRO with action TRANSFERSPREADSHEET. >> >> > Regards, >> >> > Kishan Reddy K. >> > kishanreddy.kethire...@gmail.com >> >> > On Jul 16, 12:29 pm, debasish <debasis...@gmail.com> wrote:> Hello >> > Everybody, >> > > I am working on a access database where in I have to import data from >> > > excel data on daily basis. I need a code so that i can update my >> > > access table with my excel file daily. >> > > Please help >> > > regards, >> > > Debasish- Hide quoted text - >> >> - Show quoted text - > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe