var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Import Problem
I have a problem for import the Excel file into Access.
It cannot be import all data. Could you help me to check it?
File Num has 2 datatypes: Number and Text. I already set the column to be Text datatype in the Excel. But, when I import the excel file into Access.
It cannot import all data.
Please let me know, thanks.
I suspect that you get records with either #NUM# or #NAME# showing up in access
if this the case you need a small macro in the excel file that is used to force the data to TEXT - this issue is known in the access/excel domain (many of us have been here)
If this is the case let me know ASAp and Ill post the macro for you
Last edited by garethfx; 10-14-05 at 16:40.