How to convert some records from MDB table to XLS file?
Example:
In the TEST.MDB I have table NAMES and fields: FName, LName, BDate and NNum.
I need to convert this records in XLS but... after converting (exporting), columns in xls must be formatted:
A column (FName): text, column width in xls = 25
B column (LName): text, column width in xls = 25
C column (BDate): custom (dd.mm.yyyy), column width in xls = 15
D column (NNum): Number (decimal places 2, 1000 separator (,)), column width in xls = 15
There is example hot to export records from mdb to xls (but without formatting xls columns) :
Dim db As Database
Set db = OpenDatabase("d:\zz1\test.mdb")
db.Execute "SELECT Names .FName, Names.LName, Names.BDate, Names.NNum INTO [Excel 8.0;DATABASE=d:\zz1\test.xls;HDR=No].Names FROM [Names] WHERE Names.FName LIKE '*jo*' ORDER BY FName"
thx2all.