[AccessD] importing from Excel

Susan Harkins ssharkins at bellsouth.net
Sun Jul 18 09:11:49 CDT 2004


I eventually did what I've done on several occasions in the past. Saved the
spreadsheet as a delimited text file and import that. The text import wizard
DOES let you define the datatype of each column  and even better, you can
bypass the  wizard and write your own routine to modify the data as it is
imported if you really need to.

===============This is probably my preference, regardless. It seems easier
to just force what I want during the import. 

Susan H. 





More information about the AccessD mailing list