Import from excel

[JoanaSantos]

Hi,

how can i import two columns from excel: "D6" and "F6:F" to one table in the access (with VBA)?

 

[Andrzejek]

Do you mean: you have an Excel file with data like:

[pre]
A B C D E F
1 colA colB ColC colD colE colF
2 123 2 D 12/12/2015 3 123
3 22 V 6 Bob 34 Susie
4 66 88 y 567 88 1/1/1939
[/pre]
And you have an empty (?) table in Access that you want those records to be there?



Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.