thanks for the reply... its possible to import data from excel to Access. Debasish
On Jul 20, 7:01 pm, VILAS CHAVAN <vilaschav...@gmail.com> wrote: > 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 athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://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
