12345678 Dedicated Member Dedicated Member Sep 1, 2004 163 0 62 Mar 26, 2009 #1 Hi, Just want to know how I can get my ItemDB from sql into ItemMDB. Using MDB Viewer Plus that comes with the 2.6 files. Any help apreciated, thanks.
Hi, Just want to know how I can get my ItemDB from sql into ItemMDB. Using MDB Viewer Plus that comes with the 2.6 files. Any help apreciated, thanks.
ρяєα¢нєя Unstookie Titled VIP Aug 19, 2008 444 23 105 Mar 26, 2009 #2 Quick step by step guide i knocked up: Make a backup copy of your Access database (Copy and Paste it somwhere) Open 2.6 Access database and delete TBL_STDITEMS Open up SQL Server Enterprise. Find TBL_STDITEMS. RightClick->All Tasks->Export Data... Select the corect database to export from (Should already be selected) and press "Next" Select "Microsoft Access" from the Destination drop menu. In "File Name" locate your 2.6 Access database and press "Next" "Copy tables and views from source data" and press "Next" Select the tables you want to copy over and press "Next" twice and then "Finish" Hope that helps. p Upvote 0
Quick step by step guide i knocked up: Make a backup copy of your Access database (Copy and Paste it somwhere) Open 2.6 Access database and delete TBL_STDITEMS Open up SQL Server Enterprise. Find TBL_STDITEMS. RightClick->All Tasks->Export Data... Select the corect database to export from (Should already be selected) and press "Next" Select "Microsoft Access" from the Destination drop menu. In "File Name" locate your 2.6 Access database and press "Next" "Copy tables and views from source data" and press "Next" Select the tables you want to copy over and press "Next" twice and then "Finish" Hope that helps. p
12345678 Dedicated Member Dedicated Member Sep 1, 2004 163 0 62 Mar 26, 2009 #3 Thanks worked, but It didnt go In order Is there any way to make It go In order ? Upvote 0
ρяєα¢нєя Unstookie Titled VIP Aug 19, 2008 444 23 105 Mar 26, 2009 #4 Not sure how to re-order it permanently but if you want to order so you can see what index number you're on, you can use: Code: SELECT * FROM TBL_STDITEMS ORDER BY FLD_ID p Upvote 0
Not sure how to re-order it permanently but if you want to order so you can see what index number you're on, you can use: Code: SELECT * FROM TBL_STDITEMS ORDER BY FLD_ID p
12345678 Dedicated Member Dedicated Member Sep 1, 2004 163 0 62 Mar 26, 2009 #5 Ok thanks alot m8, will try this now. Upvote 0