Lowell (4/14/2011)
toddasd (4/13/2011)
There is no importing an Access database in SQL Server.not sure what you mean by that... a data source is just a data source.
maybe you mean the other functionalities from Access, like Forms, and not the data?
you can import the data no problem with the new ACE drivers.
Maybe my phrasing is bad there, but what I assume suryagiri meant is "how can I take this accdb file and make it into a sql server database?" and I'm just saying there is no "import Access file" in SS.
If I was importing data from Access, I'd probably use openrowset. I haven't heard of ACE drivers, can you link to some info?
______________________________________________________________________________
How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.