2006-09-24 21:44:20 · 4 answers · asked by Anonymous in Computers & Internet ➔ Software
Create a new module and type in:
DoCmd.TransferSpreadsheet
Be sure you put a space at the end of the command. Access will prompt you for the parameters needed for sucessful execution of the command. It is best to do the transfer manually first, creating a transfer Specification that you save. Put the name of the transfer spec into your DoCmd.TransferSpreadsheet command and your transfer will behave better.
Good Luck!
2006-09-25 05:56:57 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
I purely now tried replica pasting each and each column from excel to get right of entry to. strategies you i had sixteen,000 rows in it and it infrequently took 2 minutes. Why pass in the process the soreness of writing a application?
2016-10-01 08:22:33 · answer #2 · answered by wardwell 4 · 0⤊ 0⤋
make/drag a OLE container/control on your form and while setting its properties at design /run time point the object to the required xls file
2006-09-24 21:58:22 · answer #3 · answered by funky_dude 2 · 0⤊ 0⤋
i think you can save it directly as a dbase 4 file...
2006-09-24 21:52:35 · answer #4 · answered by lnfrared Loaf 6 · 0⤊ 0⤋