Export data to Excel

[esskaykay]

I’d like to import ADDRESS field into a cell (or cells) in an Excel spreadsheet based on the DATE keyed-in a specific cell. There may be numerous addresses for the same date.

Example:
Spreadsheet Cell B7 = 6/12/06

Returns from the tblConstDate Access Table into a cell (or cells) in the spreadsheet:
1206 Wisconsin Ave.
1224 Wisconsin Ave.
1313 Wisconsin Ave.

Thanks,
SKK

 

[llkhoutx]

You can't filter invoice on import.

I suggest that you link the Excel file and then query that linked table for what you want.

 

[gromit]

Hi -

Not sure what specifically you are looking for assistance with.

If you can write a query that will return the related addresses, then you can write those records into a spreadsheet.

Do you have to search the spreadsheet to find the matching address?

- g

 

[esskaykay]

I'll have to try linking the spreadsheet. Probably won't happen till next week.

Thanks,
SKK