How to import..

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 28 Dec 2005 19:12 GMT

How do I import data from an excel sheet to an access database table
,excluding the columns that are hidden ?

Also this worksheet is among one of the three other worksheets in a
workbook,so how do I specify just this worksheet while importing?

Thanks,

Roy

Reply to this Message

Jana - 28 Dec 2005 21:10 GMT

Roy:

Check out this Microsoft Knowledgebase Article that describes something
similar to what you are looking for. It applies to Access 2000,
though. You could modify the function to allow you to feed in the
sheet name rather than having it hard-coded in. Unfortunately, I don't
know how you would exclude hidden columns. Perhaps someone else knows
that part :)

Here's the link:
http://support.microsoft.com/kb/210379/en-us

HTH,
Jana

Reply to this Message

Chuck Grimsby - 28 Dec 2005 23:10 GMT

Think of a excel spreadsheet like it was an external Access database.
Each column is a field, each sheet is a separate table.

Access will let you link to whatever spreadsheet you want (or, using
'print areas', whatever portion of a spreadsheet you need), and then
write (and execute) your SQL import statement accordingly.

>How do I import data from an excel sheet to an access database table
>,excluding the columns that are hidden ?
>Also this worksheet is among one of the three other worksheets in a
>workbook,so how do I specify just this worksheet while importing?

Signature

Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing

Reply to this Message