That usually indicates that the format of the spreadsheet is incorrect. Highlight each column of the spreadsheet and then set the format as follows:
Account No - Text
Debit - Numeric
Credit - Numeric
Reference - Text
Doc - Text
Line Desc - Text
Company - Text
If this still doesn't work, start...
I didn't use a check list, I basically selected from sysobjects where type = 'u' and then went through each table manually. It would be completely different for every customer, due to different modules and setups etc, so virtually impossible to use the same set of scripts. One tip, if you still...
I've managed to merge two databases together without any issues. It was a long a painfull task, took 2 days and 4000 lines of SQL Scripts, but it worked and 2 months down the line there have been no problems.
I basically looked at every single databases table individually, re-mapped every...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.