M
marctupper
How can I get my 300 worksheets to convert to ACCESS withouusing the HTML option (it wont work for large files).Any ones assitanc
with this would be greatly appreciated
How can I get my 300 worksheets to convert to ACCESS withouusing the HTML option (it wont work for large files).Any ones assitanc
with this would be greatly appreciated
G
George Nicholson
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,
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,
N
Norie
Why not (in Access) goto File>Get External Data... and link/import th
worksheets
worksheets