Re: Can't export actual text - Get #### instead

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


Dave,

Thank you, yes the cells were formatted as Text, I changed them to
General and it worked just fine in exporting the info.

Now off to figure out my SQL issue, SQL does not like the data for some
reason now.................

arrrgh, got to love data manipulation, nothing is ever as simple as it
should be ;-)

Thank you again for helping me to get this far!


--
confuzedagain
------------------------------------------------------------------------
confuzedagain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29439
View this thread: http://www.excelforum.com/showthread.php?threadid=491474

.

Relevant Pages

  • Re: SQL
    ... to have an ability to place things into cells ... It is a language issue then. ... An RDBMS engine that may ... Put a program code in a relational table and write compiler in SQL ...
    (comp.object)
  • Re: Computing Averages in MS Excel
    ... > After she said that she couldn't simply filter out the missing data, ... > I set up four cells that would take functions on that area: ... > So here's my answer: In MS Excel, ... > would use an empty cell to represent the SQL NULL. ...
    (comp.databases.theory)
  • Moving data from one machine to another
    ... I have some SQL that extracts data from a database into a text file ... So I'm exporting the data to perl sticking it into a hash, ... with Storable and emailing the file to another machine where procmail ...
    (comp.lang.perl.misc)
  • Re: Passing multiple rows to a table via a stored procedure. Possible?
    ... Using SQL ... > SP to query this XML and insert records in one shot. ... > "Bob Holmes" wrote in message ... The user can then change the values in the cells. ...
    (microsoft.public.vb.database.ado)
  • RE: Copy/Select a Row
    ... I have no problems retrieving the data from SQL, I even go back to the Query ... all the 5 cells into a different location, for instance, if the ...
    (microsoft.public.excel.programming)