MS SQL Query Error


MS SQL query error from MS Office 2010 excel;

Select ColGroup, Location Code,Description From DB2011.dbo.DB$Purch_Inv_Line

Error message: Incorrect syntax near ‘Line’

did i miss something?

thank you.

Hi Glennyboy,

Could you say a bit more about your problem. Where are yo doing this and what tool are you using in Excel?

Hi Erik,

Thank you for the quick reply.

  • connect to ms sql database from ms excel 2010

  • filtering data before importing from sql database in excel

thank you.

Hi Glennyboy,

Well for a starter then those table names looks wrong. There are no table called Purch_Inv_Line in NAV. Are you sure you’re even connecting to a NAV database? Or is it a custom table?