🚀 go-pugleaf

May be $Sheet1 ($ at beginning) will help you. You can also use

Select * from NamedDiapason

where NamedDiapason is name of diapason in Excel file.

I also sent you a demo that shows this.

>>And the other thing, how can one test this SQL statement other than
running the program
I do not understand what you need.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com


"Andre Hayward" <jorhaypi@mweb.co.za> �������/�������� � �������� ���������:
news:3d4d1177_2@dnews...
> Vassiliev
>
> Thanks again but when trying to implement the stories I got various
> error message which ranges from a syntax error to "The application has
> improperly defined a Parameter object" when I include the statement
> literally.  The square brackets normally indicates an option.  Jet SQL
> in neither helpfull in their "source" part of the statement.  I've
> tried combinations such as:
>
> ... from "Sheet1$" in "Excel...xls" to
> ....from "Sheet1$ in Excel....xls" to
> ....from [Sheet1$] in "Excel.....xls" to
> .....
> but just don't get the syntax correct.  And the other thing, how can
> one test this SQL statement other than running the program.  If you
> try to open a query it tries to execute the SQL property and this is
> not what you want.?
>
> Thanks in advance
>
> Andre Hayward
>
> >Connect to Access db and execute
>
> >Select * into NewTable from [Sheet1$] in ""[Excel
> >8.0;Database=C:\Temp\ExcelFile.xls]
>
> >NewTable should not exists in Access db. If you need add data to existing
> >table, use
>
> >Insert into DestTable(Col1, Col2, Col3) Select Col1, Col2, Col3 from
> >[Sheet1$] in ""[Excel 8.0;Database=C:\Temp\ExcelFile.xls]
>
> >Regards,
> >Vassiliev V.V.
> >http://www.oledbdirect.com
>
>
> >"Andre Hayward" <jorhaypi@mweb.co.za> �������/�������� � ��������
���������:
> >news:3d3a3373_1@dnews...
> >> "Shaun" <nospam@nospam.com> wrote:
> >>
> >> >I'll post this answer in case anyone is interested, even if I have
> >answered
> >> >the question myself.
> >>
> >> Hi Shaun,
> >>
> >> Yes, I'm very interested thanks.
> >>
> >> One of the thinks I need to do some time in the future is to upload
> >> Excel spreadsheet data into an Access database.  Please advise on the
> >> origin of the "online tutorial".
> >>
> >> Best Regards
> >>
> >> Andre
> >>
> >>
> >>
>
>
>
>