Importing Excel Data into Access

S

Sammie 1960

Simple question...in previous versions of Access when I went to import an
Excel file there was an Advance (or something like that) button that I could
click and a window would open giving me options to include/not include a
field, set data types etc. But I don't see any thing like that in Access
2003. The one screen in the import process that I think is suppose to allow
me to skip fields only gives me the first field name, no drop down menu.
Which means I would have to type each field name and click whether I want to
import the field or not. This seems cumbersome to me. Am I missing
something?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top