Database

Retrive data from Access table

16-Nov-10 0:02

chandru222 wrote:
i have successfully inserted image in database but i couldn't update it

Why not? Did you get an error? What did it say?

I are Troll Suspicious | :suss:

vijay248215-Nov-10 2:17

vijay2482

15-Nov-10 2:17

Hi all,

Eddy Vluggen15-Nov-10 4:45

15-Nov-10 4:45

vijay2482 wrote:
I would like to know how to retrive data from Access table to a excel spread sheet with a click of a button in the excel spreadsheet.

Using VBA. I don't have the exact code - you'll have to search a bit Smile | :)

I are Troll Suspicious | :suss:

Blue_Boy15-Nov-10 9:51

Blue_Boy

15-Nov-10 9:51

Better start to learn C# or any another programming language.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

www.aktualiteti.com

jschell16-Nov-10 9:00

jschell

16-Nov-10 9:00

Blue_Boy wrote:
Better start to learn C# or any another programming language.

You can use C# as a macro language in Excel?

Eddy Vluggen16-Nov-10 9:15

Adding mysql data to postgresql

16-Nov-10 9:15

Like this[^] Poke tongue | ;-P

I are Troll Suspicious | :suss:

franrtorres7714-Nov-10 1:51

franrtorres77

14-Nov-10 1:51

Hi there

I need to add periodically some data from a remote mysql database into our postgresql database. So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Best regards

Re: Adding mysql data to postgresql

Eddy Vluggen16-Nov-10 0:11

Re: Adding mysql data to postgresql

16-Nov-10 0:11

franrtorres77 wrote:
So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?

Perhaps the Sync Framework[^]? I'm not sure on the performance though.

I are Troll Suspicious | :suss:

RaviRanjanKr17-Dec-10 18:36

RaviRanjanKr

17-Dec-10 18:36

Addy already given you a perfect Link, you can also try the given link
Exporting MySQL and PostgreSQL Database Contents[^]

Hope it will work for you.

MySQL Select help required

djhankypark12-Nov-10 12:11

djhankypark

12-Nov-10 12:11

Could someone pont me in the right direction here cos I am pulling my hair out and I have little to start with lol

I am working with 3 tables

User Table:
Auto_ID
User_Name

Profile Table:
Auto_ID
User_ID (This is taken from the Auto_ID in the User Table e.g. 20)
Prof_Img

Comments Table:
Auto_ID
Message_To (This is taken from the Auto_ID in the User Table e.g. 41)
Message_From (This is taken from the Auto_ID in the User Table e.g. 20)
Message

I need to be able to display the Prof_Img for who the message was _to and _from I just can't figure how to get the individual picture references from the same table in the same query. I can get one of the pictures but not both, am probably not thinking about it correctly, well obviously I am or it would work lol

Oh and I need the User_Name to go with each relevant picture

If someone could give me a little guidance please it would save my hair line lol

Many thanks in advance

Regards

Ray

Re: MySQL Select help required

Luc Pattyn12-Nov-10 12:55

Re: MySQL Select help required

12-Nov-10 12:55

OK, you need two joins to the same tables (once for from, once for to; and both once for name, once for image); this will only work when you use aliases to discriminate the identical tables.

This will not be correct, but indicates the technique; try something like this:

SELECT FU.Name, TU.Name FROM Comments
JOIN User as FU ON Comments.Message_From=FU.Auto_ID
JOIN User as TU ON Comments.Message_To=TU.Auto_ID
WHERE Comments.Auto_ID=MessageID

which, once correct, you can extend to also handle the images.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

djhankypark23-Nov-10 7:29

djhankypark

23-Nov-10 7:29

I finally got to sit and try your suggestion and this was wonderful help thank you so much.

I do have another question about this which I will post a new messgae for shortly.

Again thank you very much for your help

Regards

Ray

Re: MySQL Select help required

Luc Pattyn23-Nov-10 7:43

23-Nov-10 7:43

You're welcome.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Timeourt

logicon12-Nov-10 1:00

logicon

12-Nov-10 1:00

Hi All,

I have a table with 50000000+ rows in SQL Server 2008 R2 Express. I am querying this database table from a .NET application. Unfortunately this table is not having any PK and probably its now possible to implement one.

When I fire my query it doesn't works due to Timeout. I get error:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

I am reading this with execute dataset method to fill my Datagridview.

Please suggest me approach I should take to make this work.

thanks

Re: Timeourt

Goutam Patra12-Nov-10 1:44

Goutam Patra

12-Nov-10 1:44

Increase CommandTimeout period to avoid this error

logicon wrote:
50000000+ rows

However I would suggest whenever you are pooling such a huge data in one dataset, if possible, try to fetch data in small chunks.

Re: Timeourt

Luc Pattyn12-Nov-10 2:24

12-Nov-10 2:24

millions of rows in a DataGridView? I pity the users then.
This forum holds some 50,000 messages, yet you see only a few (say 25) of them at once.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Use a where clause

David Mujica12-Nov-10 3:08

David Mujica

12-Nov-10 3:08

Sounds to me like you are trying to fetch way too many rows in one shot. You should re-think your logic and select only the rows you really need in your applicaiton.

If you really need to accessing millions of rows, then maybe you should be using a datareader and not try to fill a dataset.

Why don't you post a brief summary of what you are trying to do any the folks here will give you all kinds of ideas on how to attack the problem.

Good luck. Thumbs Up | :thumbsup:

Luc Pattyn12-Nov-10 3:10

12-Nov-10 3:10

you're talking to the wrong person here.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Oops, my bad

David Mujica12-Nov-10 5:32

David Mujica

12-Nov-10 5:32

Yep.
I replied to the wrong thread. My previous comment should have been applied to the original author, "logicon".

Sorry Luc.

logicon12-Nov-10 9:03

logicon

12-Nov-10 9:03

Hi David,

You are correct, I should use datareader.

The requirement is to provide a tool which brings rows in Excel from SQL Server so that end user can play with it using pivot and other excel stuff. What I initially planned was to write Excel Add-in. Unfortunately due to version issue (I had Excel 2007 and end user is having Excel 2010) I decided to write Windows Form Application which will have a DataGridView and "Export To Excel" button.

Internally, SqlDataAdapter 's Fill is used here in my current code.

I will try the DataReader and share the result with all you

Thanks Everyone.

PIEBALDconsult12-Nov-10 9:36

PIEBALDconsult

12-Nov-10 9:36

Use a DataReader to write a CSV file -- the user can then open the CSV in Excel. Slick as snot.

Mycroft Holmes12-Nov-10 10:58

Mycroft Holmes

12-Nov-10 10:58

Use SQL server to output the resultset to a CSV file on a shared folder - slicker than snot!

Never underestimate the power of human stupidity
RAH