first of all i introduce. i am a novice and doing one very small application in access using VBA.
i have a table called "input" in a file called "book1"and i can export it using the code.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "input", "z:Book1.xls", False, "Sheet1$"
it works fine as it exports the data.
i have couple of problems if someone could help me with that it will be great.
1. whenever it exports the data it makes the same number of blanks where the old data file was.
so after exporting few times there are hell of blank lines on top.
2. when i export data it exports all the data as "Text" format but i have few items as number in my access table.
is there a way that i can export the data in the same format as the actual table in access is.
3. anyway i can email the table to myself using VBA code.
as i mentioned i am new to Access databases and VBA . help will be much apreciated.