Export to Excel - Number changes to Text

  • Thread starter Thread starter Raja
  • Start date Start date
R

Raja

We recently upgarded to Office (XP) 2002
Whenever I export or copy data from Access and paste it
or open in in Excel all my columns change from a Number
format to a text format. I have to then select the
colums and convert them to Numbers in Excel in order to
add or manipulate them. Does anyone know why this
happens and what I can do to aviod this.......

Help is greatly appreciated
 
Raja said:
Whenever I export or copy data from Access and paste it
or open in in Excel all my columns change from a Number
format to a text format.
Click to expand...

It all depends on the workbook. Best thing is to create it with the
correct data types. As a demo, run these two queries from the SQL
window of any MS Access query (Jet 4), then open and inspect the
created workbook:

CREATE TABLE
[Excel 8.0;database=C:\NewWorkbook.xls;].Sheet1
(
MyNumCol INTEGER,
MyTextCol VARCHAR(10),
MyDateCol TIMESTAMP
)
;

INSERT INTO
[Excel 8.0;database=C:\NewWorkbook.xls;].Sheet1
(MyNumCol, MyTextCol, MyDateCol)
VALUES (37000, 37000, 37000)
;

--
 
Back
Top