Upgrading MS Access from 97 to SQL server 2012 express

[jdy0803]

I have a plan our database from MS Access 97 to SQL server 2012 express.
The connection string will be changed, of course, but I don't know how much SQL statements should be changed except it.
I want to know which part of SQL statement should be modified in my VB6 program.
This information will be helpful for me to calculate the time required for program modification roughly.
Can somebody who experienced this kind of work give some information?

[DataMiser]

Well for starters any queries that use a Date field with # delimiters will need to be changed from #s to single quotes.
Beyond that it depends on your queries there are some functions that are supported in MS Access but not in other databases.
There are also some extended properties that will not be available in SQL Server. This is only an issue if you are using those currently.

[jdy0803]

Thanks for answer.
May I ask you in regards to # delimeter?
For example, how can following SQL statement be modified in SQL server?
cmd.CommandText = "SELECT * FROM mytable WHERE createdate = #07/24/2014#"
I don't get what you mean "...use a Date field with # delimiters will need to be changed from #s to single quotes"

[dee-u]

"SELECT * FROM mytable WHERE createdate = '07/24/2014'"

[si_the_geek]

Thread moved to the 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

[jdy0803]

Is ' delimeter used for string as well?

[DataMiser]

String delimiter is single quote in both Access and SQL Server