Access Question

Okay.

I have an Access97 database front end with a SQL 2000 backend. Here is one of my problems - I am going to start small and work my way up.

I have a text field that contains numbers. Example 0003. The reason it is a text field is because of the leading zeros. I need to extract this field to excel. The problem is, when I extract the field it turns it into a number and drops the zeros. I have tried using a string function. I have tried adding an ' before the first 0. I have tried formatting the field. So far nothing seems to work. Does anybody have any suggestions???

That's strange. EVerytime I export from access to excell, it treats anything in a text field as a string (ie print("0003")) and drops it in excel. What version of excel? One thing you might want to try is converting to plain text first, comma delimited values and see if you can import that txt file into access. It will read everything in dbl quotes as strings, not numbers.

Otherwise, in excel, you will need to lead numbers with a ' in order to maintain it's format.

Excel 2000. Access97. SQL Server 2000.

I have even tried adding an ' before the number - it comes out as '00003. I think I found away around this though. If I extract the query instead of the report, it does not drop the zero's! Go figure