Syntax for MSAccess

[dlafrenz]

I have the DSData Sever working and I can see data in Excel with the following syntax:

=DSData|New_Temp_Profile!'Y1'

Access doesn't like the piping bar after DSData.  What would the correct syntax be?

Thanks,
Dave

[Controls Guy]

Have you checked Access's documentation and the interwebs for examples?  I'm sure there aren't going to be any DSData examples (in the official docs anyway), but that issue isn't specific to DSData anyway, and there might be something analogous that would tip you off to what syntax it wants.

[b_carlton]

try here  http://office.microsoft.com/en-us/access/HA012288191033.aspx