Importing Excel into Access with VB

  • Thread starter Thread starter T2
  • Start date Start date
T

T2

I need some code ideas to import Excel into Access using
VB. I need to use VB because the Excel column formats are
not always consistent.

I'm importing a fairly simple spreadsheet.

Any assistance would be greatly appreciated.
 
* "T2 said:
I need some code ideas to import Excel into Access using
VB. I need to use VB because the Excel column formats are
not always consistent.
Click to expand...

Are you sure you are talking about VB.NET?
 
Hi T2,

Maybe you can try it using OleDB here are Oledb connection strings including
Excel.

http://www.connectionstrings.com/

Watch special to that Imex I never used that, so I dont know if it will
works for you

And this is a sample SQL string, watch that $ sign.
OleDb.OleDbCommand("Select * from [sheet1$]"

I hope this helps,

Cor
 
Back
Top