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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Export
Yarddy, To get every single field and record from a table use the following SQL: SELECT * FROM table_name (this case Stock_Rec)- croix18
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Numeric Only Fields
I was wondering, is there a way to tell if a field contains only numeric characters? I have to exclude numeric fields and keep alpha-numeric values for the select statment. I've looked into LIKE and NOT LIKE but do not think they will do the job. I am attempting this at first using Business...- croix18
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
-
Import from Excel Error
Ok, got it to work on the Importing front, using acSpreadsheetTypeExcel5. Some documentation on what these mean would be GREAT, Microsoft. [mad] However, I still can't get the Excel process to release from RAM. The END method doesn't seem to be working from this forum Excel process still...- croix18
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import from Excel Error
Might have missed one now that I'm looking at them, I think it was 4 or 5...going to try them both now, just in case.- croix18
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Import from Excel Error
Hey Everybody, I'm currently running Access 2002. What I am trying to accomplish is to "pass reporting off" to another person. I'm assuming they know very little of Access/Excel and therefore hope to automate 95% of the process. The problem is they have a report where it will always return...- croix18
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
