🚀 go-pugleaf

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
>>
>>
>>