Insert Into Excel

  • Thread starter Thread starter OldButStillLearning
  • Start date Start date
O

OldButStillLearning

Hello, I have read a lot of excel files but I have never updated one until
now....and it is not working for me.

I am getting an error indicating that the table does not exist.

My SQL statement looks like the following:
Insert into Receiving (PO_ID, Recv_Qty, Recv_Date, Line_Nbr, Inv_Item_Id,
Receiver_Id, Recv_IBU, UOM, Shipto_ID, Vendor_ID, Vend_Part_Num, Lot)
values ('0009390626', '1', '2009-03-24', '1', '0000210208', '0100891544',
'01001',
'EA', 'STG01-07', '0000008207', '3HE00028AA', '')

It is asking me to check the name "Receiving" to see if it is spelled
properly. It is. The file did successfully open per the connection property
for this.

The examples I have seen indicate that I do not supply the "$" after the
table name, as I would in select statements. And when I try, that gives me
an invalid SQL statement error.

So what is the problem/secret to inserting rows into excel.

Thanks in advance for your assistance!!!
 
You must use the $ symbol after the table. Try enclosing the table name in
square brackets in your queries
Like [Receiving$]
 
Back
Top