Quizzes & Puzzles28 mins ago
Help! Crystal reports / MS Excel / MS Access
2 Answers
Bit of a pickle!
I'm trying to export data from Crystal Reports to Excel then use Access to import from Excel.
The Crystal report has over 85,000 records but Excel only allows 65,585ish records on sheet 1 and the rest on sheet 2.
Access only looks for data in one of the sheets, thus not importing all the data
How can I get the 85,000 into Access from Excel?
Can I get data straight from Crystal to Access.
Should I choose an alternative to Excel, and if so, what type of file?
I'm trying to export data from Crystal Reports to Excel then use Access to import from Excel.
The Crystal report has over 85,000 records but Excel only allows 65,585ish records on sheet 1 and the rest on sheet 2.
Access only looks for data in one of the sheets, thus not importing all the data
How can I get the 85,000 into Access from Excel?
Can I get data straight from Crystal to Access.
Should I choose an alternative to Excel, and if so, what type of file?
Answers
Best Answer
No best answer has yet been selected by nobfelt2. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.You say you are trying to export data from Crystal Reports.
Crystal Reports is a report writer and the data it is using must in a database (SQL Server for example).
Would it not be easier to move the data from the underlying database (SQL Server for example) direct to Access.
Why do you need to have Crystal Reports in the picture at all ?
Crystal Reports is a report writer and the data it is using must in a database (SQL Server for example).
Would it not be easier to move the data from the underlying database (SQL Server for example) direct to Access.
Why do you need to have Crystal Reports in the picture at all ?
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.