Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem exporting to Excel

Status
Not open for further replies.
llafretaw

llafretaw

MIS
Oct 2, 2001
64
GB
Hi,

I'm using a Microsoft Access 97 VBA frontend to retrieve records from a Sybase backend which get exported to Excel 2000.

The problem I'm having occurs when I convert the numeric data (on the Sybase end)to be decimal and greater than 15 in width. This prevents me from using some of the built in functions like SUM in the Excel spreadsheet to which the data is automatically exported to, unless I save the output as .cvs.

Is there a way around this, or is it some type of known Excel problem?

Thanks

 
Status
Not open for further replies.

Similar threads

FrankMars
  • Locked
  • Question
Exporting Records to Excel 1
Replies
6
Views
719
Andrzejek
Andrzejek
Viswa.R
  • Locked
  • Question
Dimension import from Autocad to Excel
Replies
0
Views
491
Viswa.R
Viswa.R
Moss100
  • Locked
  • Question
Concatenation problem 3
Replies
5
Views
1K
Moss100
Moss100
Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
687
Andrzejek
Andrzejek
hermanlaksko
  • Question
Convert PDF file to text
Replies
6
Views
383
hermanlaksko
hermanlaksko

Part and Inventory Search

Sponsor

Back
Top