Re: $$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

2010-07-22 Thread debasish
thanks for the reply... its possible to import data from excel to Access. Debasish On Jul 20, 7:01 pm, VILAS CHAVAN wrote: > Hi > is it posible, to export data excel to access using vba code > > vilas chavan > > On 7/19/10, Kishan Reddy, K wrote: > > > Hello, > > > Very simple. > > > Select the

Re: $$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

2010-07-20 Thread VILAS CHAVAN
Hi is it posible, to export data excel to access using vba code vilas chavan On 7/19/10, Kishan Reddy, K 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

$$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

2010-07-19 Thread Kishan Reddy, K
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 exce

$$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

2010-07-19 Thread debasish
I am a novice in macro... could you please elaborate more on this.. Thanks & regards, Debasish On Jul 18, 8:40 pm, Kishan K 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 

$$Excel-Macros$$ Re: VBA code for importing data from excel to Access table

2010-07-18 Thread Kishan K
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 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