Convert EXCEL to ACCESS

How can I get my 300 worksheets to convert to ACCESS without
using the HTML option (it wont work for large files).Any ones assitance
with this would be greatly appreciated.


--
marctupper
Posted via http://ms-os.com Forum to Usenet gateway

Why not (in Access) goto File>Get External Data... and link/import the worksheets?

Within Access:
Table>New>Import Table
or
File>GetExternalData>Import

Both methods activate a wizard to walk you through the necessary steps
Default is 1 sheet = 1 table, but you may be able to append identically
structured sheets to a single table during import. If not, you can do it
after they are imported.


HTH,
--
George Nicholson

Remove 'Junk' from return address.


"marctupper" <marctupper.1q9pky@no-mx.gateway.localhost> wrote in message
news:marctupper.1q9pky@no-mx.gateway.localhost...
>
> How can I get my 300 worksheets to convert to ACCESS without
> using the HTML option (it wont work for large files).Any ones assitance
> with this would be greatly appreciated.
>
>
> --
> marctupper
> Posted via http://ms-os.com Forum to Usenet gateway
>