import data from XL into Access

[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.c om

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

[Homer J Simpson]

Re: import data from XL into Access


"m. via DotNetMonster.c om" <u16975@uwe> wrote in message
news:5d2eb307ac f14@uwe...
[color=blue]
> 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?[/color]

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