| | |
|
|
|
Migrate VIEW from Access to SQLserver ??? |
|---|
| message from YURYSSG on 3 Jun 2004 |
I migrated a DB from Access 2000 to SQLserver 2000.
The tables are OK, but I see the old Access views... as TABLE in
SQLserver!!
Any suggestions?
|
| Tony Toews replied to YURYSSG on 04 Jun 2004 |
FWIW I was able to programmatically make views out of many of my
Access queries.
I had much more code than this but the basics were as follows.
strNewSQL = adhReplace(Q.SQL, vbCrLf, " ")
strNewSQL = Left(strNewSQL, InStr(strNewSQL, ";") - 1)
strNewSQL = ConvertTrueFalseTo10(strNewSQL)
tagRetryAfterCleanup:
Set myquerydef = dbsPermanent.CreateQueryDef("")
'Q.Name & " DAO Test")
myquerydef.ReturnsRecords = False
myquerydef.Connect = strConnect
myquerydef.SQL = "CREATE VIEW [" & strQueryName & "]
AS " & strNewSQL
myquerydef.Execute
myquerydef.Close
Tony
|
|
Archived message: Migrate VIEW from Access to SQLserver ??? (Microsoft Access Database)
