Import Excel Datasheet

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

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
 
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),";")
 
John Nurick said:
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.
Click to expand...

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.

--
 
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.
Click to expand...
 
Back
Top