Import Excel Datasheet

[Oded Kovach]

Hello there

I need to import excel datasheet into access table.

The excel workbook can provide more then one worksheet.

How can i know how many worksheets are on excel workbook, their names and
import one of then to access table?

any help would be useful

 

[John Nurick]

Hi Oded,

Presumably you're trying to do this in VBA code. If you go to
http://groups.google.com and search for

"drink soup audibly" group:microsoft.public.excel.programming

you'll find a message from onedaywhen that includes a GetWSNames()
function. This returns an array containing all the worksheet names. You
can use something like the following in the Load event of your form to
put the names into a combobox (cboSheetNames). The combo's RowSourceType
must be set to "Value List".

Dim strWBKName As String

strWBKName = "C:\Folder\File.xls"
Me.cboSheetNames.RowSource = Join(GetWSNames(strWBKName),";")

 

[Jamie Collins]

If you go to
http://groups.google.com and search for

"drink soup audibly" group:microsoft.public.excel.programming

you'll find a message from onedaywhen that includes a GetWSNames()
function.

LOL! Try searching the entire www for another occurrence of that
phrase. I've seen Steve Kass using GUIDs to reference his key posts
(e.g. try searching google groups for
9647763D-823F-46CB-9704-18F15D16E687) but I seem to have inadvertently
invented an alternative using memorable but uncommonly used phrases!

Jamie.

--

 

[John Nurick]

Let's make a habit of it.

LOL! Try searching the entire www for another occurrence of that
phrase. I've seen Steve Kass using GUIDs to reference his key posts
(e.g. try searching google groups for
9647763D-823F-46CB-9704-18F15D16E687) but I seem to have inadvertently
invented an alternative using memorable but uncommonly used phrases!

Jamie.