Last post Aug 10, 2009 03:50 AM by kamii47
Aug 09, 2009 07:32 PM|reza141414|LINK
i have somthing about 400 access db file and i want to import(convert)
them into the sql db.
i'm using the upsizing wizard of the access 2007.
my problem is when i run wizard for the table with about 100 row(or
more) the result is: the table is created in sql db but with no data
(only the struct on access db converted). but if my table have less
than 10 row the wizard work's well...
or any other idea to convert the access to sql db.
Aug 10, 2009 01:21 AM|kamii47|LINK
Which version of Sql server you are using?
If using sql server 2005 or later you can simply does this with sql server management studio.
Aug 10, 2009 03:12 AM|reza141414|LINK
i'm using sqlserver2000. but it's not important! if u have any solution for 2005 ver, tell me about it.
Aug 10, 2009 03:50 AM|kamii47|LINK