469,902 Members | 1,799 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,902 developers. It's quick & easy.

how to import .XLS file in the database

dear all,

i want to import excel file in my database table.
plz give me the whole coading.


thanks and regards
saurabh
Nov 1 '07 #1
3 1633
markrawlingson
346 Expert 100+
Hello saurabh590,

Please note that the experts in this forum volunteer their time and experiences to help people work through programmatic issues, we do not write entire scripts for people.

If you'd like someone to give you the entire code, please go here to the job forum.

Sincerely,
Mark
Nov 1 '07 #2
plz update the status
Nov 30 '07 #3
jarekz
13
dear all,

i want to import excel file in my database table.
plz give me the whole coading.

thanks and regards
saurabh
I don't have the whole coding for you, but I can give you a hint. You have to open code editor (alt + F11 if memory serves) and type DoCmd.TransferSpreadheet . Now click F1 to read help about the parameters. It's not very difficult.

Good luck!
Dec 16 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Steve Holden | last post: by
5 posts views Thread by Steve Holden | last post: by
4 posts views Thread by news | last post: by
2 posts views Thread by David Berry | last post: by
7 posts views Thread by Randy | last post: by
9 posts views Thread by a | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.