excel to access

[awake2424]

Is it possible to export excel 2003 data to an access 2003 form into a specific field?

For example:

If in excel:

Column: Name: Jim Adams Column: Phone: 773-655-2083
Column: Name: Paul Smith Column: Phone: 724-888-2525

can that data be exported to access automatically:

in table:
Field: Name
Field: Phone

Thanks.

 

[Steve R.]

Yes. You can use DoCmd.TransferSpreadsheet. I have not used.

I used this and this.

 

[rheeyum]

Ahmmmm... File/Get External Data/Import or Link?

I dont know if this is what you need but I am using this... You can try that to other application like Outlook too.

 

[The_Doc_Man]

To keep it simple, I usually do that kind of import in two or three steps.

First, just import the raw spreadsheet.

Second, manually or by query or both, remove anything from the imported table that cannot be useful, like title import or blank rows where the import fields have nothing in them.

Last, do an append query to the "real" table where you wanted the data. That way, you can do format changes on the fly in that final append.

There is a more direct way to do it with VBA code and opening an Excel Applications Object, but unless you are planning to repeat this step very often, what I suggested is probably better for a one-time import.