import excel column width

[Bala]

Hi,


I set the MS-Excel column width to 18. But when I import into MS-access, the column width is NOT 18. Pls. help.

By the way, can I specify the 'specification when I import Excel file' ?. FYI, I can do it when I import TEXT file.


-Bala

 

[Corticus]

Hi Bala,

Build the report like you want it to look in Access.

Then export the report. When you do this, the formats from the report in Access are transfered to the resulting Excel report.

Use code as follows:

DoCmd.OutputTo acReport, "MyReport", acFormatXLS

Replace MyReport with the report your exporting.

When run, a dialog box will pop up asking where to save, which you usually want.

HTH,

 

[bat17]

Access will not format the column widths to match Excel.
As a general rule you should not use the tables in Access to work with data anyway but use forms. Forms give you a much better control of data validation.

If you import by using the wizard you can save the import specification under the advancwed options and then use this saved spec' when you import from code.
HTH

Peter

 

[bat17]

Access will not format the column widths to match Excel.
As a general rule you should not use the tables in Access to work with data anyway but use forms. Forms give you a much better control of data validation.

If you import by using the wizard you can save the import specification under the advanced options and then use this saved spec' when you import from code.

HTH

Peter

 

[Corticus]

My advice was for keeping formats when exporting from Access,

I didn't notice that you are trying to import formats into access tables. Just make a report or query that refers to the imported table. Save this query or report and the formats (column widths) will be saved with it.

HTH,