Access怎么导出excel!

[liguangya163]

将Access数据库的表如何导出到EXCEL？？？？
或者用sql语句查询出来的数据怎么导出？？？
该怎么写？？写到哪？？？ 语言我会.net 我是新手 能做个示例吗？

[wwwwb]

jetsql:
select * into [excel 8.0;database=r:\temp\123.xls].sheet1 from tt

[ACMAIN_CHM]

SELECT * INTO [Excel 8.0;Database=c:\book1.xls].[Sheet1] FROM Customers
SELECT * INTO [Sheet1] IN '' [Excel 8.0;Database=c:\book1.xls] FROM Customers
SELECT * INTO [Sheet1] IN 'c:\book1.xls' 'Excel 8.0;' FROM Customers"
INSERT INTO [Sheet1$] IN '' [Excel 8.0;Database=c:\book1.xls] SELECT * FROM Customers
INSERT INTO [Sheet1$] IN 'c:\book1.xls' 'Excel 8.0;' SELECT * FROM Customers

[liguangya163]

[Quote=引用 2 楼 acmain_chm 的回复:]
SELECT * INTO [Excel 8.0;Database=c:\book1.xls].[Sheet1] FROM Customers
SELECT * INTO [Sheet1] IN '' [Excel 8.0;Database=c:\book1.xls] FROM Customers
SELECT * INTO [Sheet1] IN 'c:\book1.xls' 'Excel ……
[/Quote]

Sheet1是什么 是查询语句吗？

[wwwwb]

是EXCEL中的工作表名