Originally Posted by
ranman256
you may want to build a macro to format the data into an importable format.
the macro would build a new sheet, say: importJobs
build data into the sheet,
then save the file AND save a copy to a generic importing file say: c:\temp\Import.xls
In access youd have c:\temp\Import.xls linked as an external table.
then run an append query to import the data.
then your steps would be:
open new excel doc,
run excel macro for reformat,
close xl.
open access,
run import macro.
done.