Prev: Force Sub Report to Show Even If No Data
Next: Paste Special, Values, Transpose
From: Don on 19 Jan 2010 23:07
I've tried looking at previous answers to my particular TransferSpreadsheet
issue, in this forum, but I cannot make them work for me.

I can make the TransferSpreadsheet work using VBA code; however, the first
spreadsheet is selected by the function. I need to specify other worksheets
in the workbook. I'm not an expert in Access VBA, so I'm requesting in a
humble manner for someone to show me how to select specific sreadsheets in
the simplest manner possible.

The line of code I used is shown below. It worked, but it selected the
first spreadsheet in my Excel file.

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblBAKERY",
Me.PATH_STATEMENT & "" & Me.FILE_NAME, True

Any help would be greatly appreciated.
--
Don Rountree
From: Gina Whipp on 19 Jan 2010 23:20
Don,

Have a look at

http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWkshts

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Don" <Don(a)discussions.microsoft.com> wrote in message
news:36C18CFD-A018-4D10-95EE-8965C2D72B7D(a)microsoft.com...
> I've tried looking at previous answers to my particular
> TransferSpreadsheet
> issue, in this forum, but I cannot make them work for me.
>
> I can make the TransferSpreadsheet work using VBA code; however, the first
> spreadsheet is selected by the function. I need to specify other
> worksheets
> in the workbook. I'm not an expert in Access VBA, so I'm requesting in a
> humble manner for someone to show me how to select specific sreadsheets in
> the simplest manner possible.
>
> The line of code I used is shown below. It worked, but it selected the
> first spreadsheet in my Excel file.
>
> DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "tblBAKERY",
> Me.PATH_STATEMENT & "" & Me.FILE_NAME, True
>
> Any help would be greatly appreciated.
> --
> Don Rountree


From: Dirk Goldgar on 19 Jan 2010 23:29
"Gina Whipp" <NotInterested(a)InViruses.com> wrote in message
news:e6yIgfYmKHA.3476(a)TK2MSFTNGP06.phx.gbl...
> Don,
>
> Have a look at
>
> http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWkshts


Darn, Gina, you beat me by 9 minutes!

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: Gina Whipp on 19 Jan 2010 23:36
Dirk,

Must be the coffee... yep, I'm still drinking it!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message
news:ejVb5kYmKHA.5840(a)TK2MSFTNGP05.phx.gbl...
> "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message
> news:e6yIgfYmKHA.3476(a)TK2MSFTNGP06.phx.gbl...
>> Don,
>>
>> Have a look at
>>
>> http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#ImpAllWkshts
>
>
> Darn, Gina, you beat me by 9 minutes!
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>


 | 
Pages: 1
Prev: Force Sub Report to Show Even If No Data
Next: Paste Special, Values, Transpose