Post reply

Importing Data from access Database backup

  • March 16, 2011 at 11:04 am

    #246927

    Hi All,

    I got an issue while importing data(Tables) from access Database.

    While Importing Tables SQL is creating table with not null for few columns though there null values in Access database( I observed for int data types) causes error while importing.

    I converted all to varchar and to null while importing and then succesfully imported.

    My questions is, on what basis SQL Taken this table definition with not null values.. I cannot check Access database and its definitions. I don't have access.

    Regards

    Ram..

    🙂

  • March 16, 2011 at 11:30 am

    #1299524

    I believe SQL uses the same logic as it uses for Excel worksheets. It checks the first 10 rows of data and assigns nullability (as well as data type) based on that information. It's a quick and dirty way of getting the information it needs for table creation without having to scan the entire file / database first.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • March 17, 2011 at 4:11 am

    #1299843

    Yes. I checked it.

    Thank you

    🙂

  • March 17, 2011 at 5:25 am

    #1299869

    I'm asking because your reply confused me a bit. Did my response actually help you out / answer your question? Or do still need this answered?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply