Home Forums Microsoft Access Microsoft Access import access db in sqlserver RE: import access db in sqlserver

  • April 14, 2011 at 11:31 am

    #1311750

    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.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!