Local Wisdom \\Share EP12:Using Access 2007 to Query Microsoft SQL 2008 Part 1

[Aragan29]

What about the Queries? I have some queries that i made in SQL Server and i would like to use that code  in access so i can create reports! i use copy and paste but access continue to give an error message dont know why... (im a noob :D) is there a "pro" way to do it?

[lwinc]

@Aragan29 In SQL you have "Select * from dbo.table". In access, it gets named "dbo_table". Thus your select statement in access becomes "select * from dbo_table". Pretty much the period gets replaced by underscores. To convert you need to do something like this:

SQL:

Select * from dbo.table t inner join dbo.table2 t2

ACCESS

Select * from dbo_table t inner join dbo_table2 t2

I show in part 2 going from Access to SQL at the 2:30 mark. EP12:Using Access 2007 to Query Microsoft SQL 2008 Part 2

[lwinc]

@Aragan29 Just post a reply if your still having issues converting the sql.

[conejo747]

Nicely done! Thanks!

[lwinc]

@conejo747 Thanks, I'm glad you found it useful!