Import Excel Datasheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oded Kovach - 21 Nov 2004 07:15 GMT

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

Reply to this Message

John Nurick - 21 Nov 2004 21:29 GMT

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),";")

>Hello there
>
[quoted text clipped - 6 lines]
>
>any help would be useful

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message

Jamie Collins - 22 Nov 2004 14:33 GMT

> If you go to
> http://groups.google.com and search for
[quoted text clipped - 3 lines]
> 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.

--

Reply to this Message

John Nurick - 22 Nov 2004 21:08 GMT

Let's make a habit of it.

>> If you go to
>> http://groups.google.com and search for
[quoted text clipped - 11 lines]
>
>Jamie.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message