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
