import data from XL into Access

microsoft.public.dotnet.languages.vb

13 Mar 2006 7:37 AM

m. via DotNetMonster.com

hi. i have to import data from xl into an existing access table. can someone
please help me? im not sure about what sort of connection string to use for
XL (im ok with the access part). also, is there a row count function in XL?

please let me know if someone out there knows.

thanks!

--
Message posted via DotNetMonster.com
http://www.dotnetmonster.com/Uwe/Forums.aspx/dotnet-vb-net/200603/1

13 Mar 2006 6:46 PM

Homer J Simpson

"m. via DotNetMonster.com" <u16975@uwe> wrote in message

news:5d2eb307acf14@uwe...

> hi. i have to import data from xl into an existing access table. can
> someone
> please help me? im not sure about what sort of connection string to use
> for
> XL (im ok with the access part). also, is there a row count function in
> XL?

XL?? Excel? Try an Access group, however IIRC you can do this directly from
Access.