Hi…all,

I have a null column when I try to import excel to access by VB language. But when I import that excel via Access’ Get External Data tools, it resulting correct data (not null).
Could someone of you explain why this happen?
Is it because my data contain many null value in 2nd column? *

Thank you,
:)

Note :
ID Discount*
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29 3.5
30 7.5