Group:  Microsoft Access ยป microsoft.public.access.macros
Thread: Transferspreadsheet

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Transferspreadsheet
"Bill Gower" <billgower[ at ]charter.net> 02.03.2006 00:20:48
From an Access Macro how do I transfer a specific worksheet into an access
table?

Bill


Re: Transferspreadsheet
"Ken Snell \(MVP\)" <kthsneisllis9[ at ]ncoomcastt.renaetl> 02.03.2006 04:53:38
Specify the worksheet name (followed by !) in the Range argument:

SheetName!

--

Ken Snell
<MS ACCESS MVP>

"Bill Gower" <billgower[ at ]charter.net> wrote in message
news:OteQD8YPGHA.1124[ at ]TK2MSFTNGP10.phx.gbl...
[Quoted Text]
> From an Access Macro how do I transfer a specific worksheet into an access
> table?
>
> Bill
>
>


Re: Transferspreadsheet
diana 03.03.2006 07:09:27
use the action :TRANSFERSPREADSHEET selecting IMPORT

"Ken Snell (MVP)" wrote:

[Quoted Text]
> Specify the worksheet name (followed by !) in the Range argument:
>
> SheetName!
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
>
> "Bill Gower" <billgower[ at ]charter.net> wrote in message
> news:OteQD8YPGHA.1124[ at ]TK2MSFTNGP10.phx.gbl...
> > From an Access Macro how do I transfer a specific worksheet into an access
> > table?
> >
> > Bill
> >
> >
>
>
>

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net