The movie mogul, who has backed films such as The Artist and The King's Speech, revealed that the politician suggested he turn a spy book into a big-screen hit.
Weinstein told The Times: "The President sent me a book the other day and said, 'Why don't you make this into a movie?'... I can't tell you [what it was]. It was a spy novel."
However, the 59-year-old decided to pass on the idea, responding with a polite message.
"I sent him an email back saying he was the most overqualified book scout I've ever had," he added.
Meanwhile, the co-chairman of The Weinstein Company is to receive the 2012 Legion d'Honneur - a prestigious award for his contribution to cinema.
Personally nominated by French President Nicolas Sarkozy, he will be honoured at a ceremony in Paris.
Weinstein said: "I am honoured and humbled by this recognition from President Sarkozy and the people of France. All my life, I have loved and been inspired by French cinema, and as a studio head it has been my pride and joy to have the ability to bring movies to audiences around the world.
"I am still the young boy who walked to the cinema in Flushing, New York to see films by the greats - Lelouch, Godard, Renoir and my personal favourite, François Truffaut. They inspired me and led me to the place I am in today. I hope to continue my friendship with France and its filmmakers for many years to come."