How to save/repeat an import from Excel

[db123625]

I get a "canned" report sent to me in Excel format. There are 21 columns of
data. The name of the report file, and the column headers never change. The
data is all simple alpha-numeric. (It's a team training update). I need to
import this data into a new table in my Database, but I only need 7 of the
columns. I can use the import wizard and manually select "Do Not Import" for
all the columns I don't need, but that is very time consuming and prone to
human error. Since I need to do this twice weekly, I really need to find a
way to make this import process repeatable. I'm not very good writing code,
but I can copy/paste with the best of them. I can provide examples of the
spreadsheet and desired table layout if that would help.

 

[Gina Whipp]

db,

Have a look at the TransferSpreadsheet function under Help. You can set up
an Import Specification with the TransferSpreadsheet and attach it to a
button on a form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm