linked Excel file

[Guest]

I am trying to update a table with data from a linked Excel file. The update
is being performed from two columns in the spreadsheet. One column contains
text; the other numbers. They are both formatted in Excel accordingly.
Sometimes the update query works. Sometimes the numeric values are not
updated.

Any ideas would be welcome.

Thanks.

 

[David Lloyd]

Greg:

It would be helpful to see the update query you are using.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I am trying to update a table with data from a linked Excel file. The
update
is being performed from two columns in the spreadsheet. One column contains
text; the other numbers. They are both formatted in Excel accordingly.
Sometimes the update query works. Sometimes the numeric values are not
updated.

Any ideas would be welcome.

Thanks.

 

[Guest]

Of course. "Temp Check-In" is the spreadsheet.

UPDATE [CHECK-IN]
INNER JOIN [Temp Check-In] ON [CHECK-IN].Packet_ID = [Temp
Check-In].Packet_ID
SET
[CHECK-IN].Store = [Temp Check-In].Store,
[CHECK-IN].PacketCount = [Temp Check-In].PacketCount

 

[David Lloyd]

Greg:

It is hard to know the exact reason, however one thing I would check is that
the numerical values are not formatted as text in the Excel file. Numeric
values can appear to be just numbers, however, they can be formatted as text
nonetheless. I have run into this issue in some of my work. If you are
using Excel 2003 (I am not sure about previous Excel versions offhand) if
the numbers are formatted as text you will see a green triangle in the upper
left corner. If you click the smart tag for the cell, you will be given the
option to convert it to a number.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Of course. "Temp Check-In" is the spreadsheet.

UPDATE [CHECK-IN]
INNER JOIN [Temp Check-In] ON [CHECK-IN].Packet_ID = [Temp
Check-In].Packet_ID
SET
[CHECK-IN].Store = [Temp Check-In].Store,
[CHECK-IN].PacketCount = [Temp Check-In].PacketCount