mssql &amp; access

biblio · 2001-08-23T04:50:01+00:00

What is the mssql Server data file extension? (like *.mdb in MS access) Can you import such files into an MS access database? Thanx, Johan.

mssql & access

biblio

What is the mssql Server data file extension? (like *.mdb in MS access)
Can you import such files into an MS access database?

Thanx,
Johan.

totof06

Hi,

1 - In MSSQL 7, the "Master Database File" has a "MDF" Extension and "LDF" for the log.

2 - You cannot import it directly into MS access... :-( I think the only solution is to generate a SQL script using "reverse engeneering" tool in the Enterprise Manager.

Good luck !

Christophe TOGNETTI.
http://www.realscale.com