Copy Excel data to Sql Table

[wattdanielm]

I would like to see a video on how to export data from access or excel to a web page. (solution to: pos inventory transactions to sync to web site at min end of day batch)

[TheMarvinglennlacuna]

please create a tutorial with vise versa of this one. SQL IMPORT TO EXCEL or if you have link for that tutorial please reply in this post and paste the link.. thanks

[videocode2]

@TheMarvinglennlacuna Sure, I will upload it tonight

[TheMarvinglennlacuna]

@videocode2 thanks man, will wait for it, and for the link . GOD BLESS YOU

[videocode2]

@TheMarvinglennlacuna Video is ready. Check my channel.

[mudmanrv]

The link to download code takes me no where... can you post the code somewhere or cut and paste to a private message for me?

[janis2006]

hi

very nice but i see a very big security problem.. what if i past a sql injection :s

it isn't safe..

[videocode2]

The excel to sql is most use for internal use not for public.

[JACENZ]

hey are you able to post the code on here cause i can't reed the code, if it's possible?

[jorgecornejo]

Really pretty good!

I'm beginner in this area but I'm studying very hard.

Now I'm going to ask u something,

I'm trying to do a Working Paper using by SQL Sentences within VBA for Excel.

Can I make a sub-search withtin the main search? for example:

Select "Teachers" Select "Math Books" from "Library"

from "School"

I would really apreciate your help

Thanks

[videocode2]

Sorry for the delay, work is madness.

You could do a Union like:

Select Teachers

from table_teachers

Select Math_Books

from table_mathbooks

Each statement can have a Where cause

The above will give you both results. I have use this method for reports.

[jorgecornejo]

Hi again, don't worry I have been working a lot too, I understand.

Thanks a lot for your time and help

I think it will be totally useful for my new tasks.

If I have any doubt I will let you know soon my friend.

Regards

[yathooo]

could you please tell me , how to do this vice versa?

[videocode2]

If you want to pull Sql data to excel the ez way is to use sql analyzier and export to csv file. Using excel external source you can pull all the data into excel sheets and your done.

[angrd020]

Thank you very much this has helped me as I have been made a SQl DBA in the past 3 weeks and had no real prior experience with it other than backing up and restoring databases as an IT task.