export access table by using VBA code.

[tariq nawaz]

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.

Regards

A learner

[June7]

1. Odd, are there a bunch of 'blank' records in the dataset?

2. The import/export wizard has a setting for this. Perhaps if you save an export specification and use that specification with RunSavedImportExport method.

Want to provide db for analysis? Follow instructions at bottom of my post.