Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
haocaocu
Starting Member
1 Post |
 Posted - 2009-02-17 : 20:19:37
|
| Sorry.Because my bad english do you have source import excels in access? You can share give me.Thanks |
|
|
Itamar
Starting Member
19 Posts |
Posted - 2009-02-20 : 13:48:14
|
| If wish to work with several different databases (Access, Excel, SQL, MySQL) and to run Query, you have third party tools you can use, like this Query tool : [url]http://www.nobhillsoft.com/MarieAlix.aspx[/url]http://www.nobhillsoft.comDatabase tools, SQL,MySQL... |
 |
|
|
Sequin
Starting Member
25 Posts |
Posted - 2009-03-02 : 09:40:16
|
| Access will import Excel data without any code - from the File menu, choose "Get external data", then "Import" - change the "files of type" to "Microsoft Excel (*.xls)", browse for the workbook, then follow the prompts.If you want to do it in code, look for "TransferSpreadsheet" in the help documentation |
|
|
|
|
|
|
Import Excel in Access