Importing Excel into Access with VB  
Author Message
SueLola





PostPosted: Sat Dec 06 16:03:03 CST 2003 Top

Visual Basic [VB] >> Importing Excel into Access with VB 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.

Visual Studio245  
 
 
hirf-spam-me-here





PostPosted: Sat Dec 06 16:03:03 CST 2003 Top

Visual Basic [VB] >> Importing Excel into Access with VB * "T2" <EMail@HideDomain.com> scripsit:
> 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.

Are you sure you are talking about VB.NET?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>
 
 
Cor





PostPosted: Sun Dec 07 01:36:39 CST 2003 Top

Visual Basic [VB] >> Importing Excel into Access with VB 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

> 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.