View Single Post
  #1 (permalink)  
Old August 5th, 2003, 12:05 AM
rpitoyo rpitoyo is offline
Registered User
 
Join Date: Aug 2003
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error Data When Convert Excel to Access

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