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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. braktoon

    SQL ORDER BY not working properly?

    its strange, that looks like my code, i have never seen this problem before, and i have run plenty of similar queries, like i said, it works for BuiltWeek, but not ShippedWeek which would seem to indicate a problem in the data, but when i sort the data by hand in the table, it comes out correct...
  2. braktoon

    SQL ORDER BY not working properly?

    hello, in one of my projects i run a query on a database and place the result in a new table. the result is supposed to be sorted by one of two fields, my code looks like: sSQL = "SELECT * INTO T4RR FROM T4R" sSQL = sSQL & strRetNo & "ORDER BY T4R." if optBuilt.value = true...
  3. braktoon

    Access TransferSpreadsheet problems

    yeah, i ended up doing this another way, everyone here uses office 97 and has JET 3.51, so a few of the features didnt work. i got access to the database and queried it directly to create the sums that i needed, much easier. thanks, justin
  4. braktoon

    Access TransferSpreadsheet problems

    ok, this is what i have: Set tdef = db.CreateTableDef("NewShipData2") tdef.Connect = "Excel 97;Datebase=" & strFile tdef.SourceTableName = Mid(strFile, intx + 1, Len(strFile) - 4 - intx) db.TableDefs.Append tdef i get a "Couldn't find installable ISAM" error, i...
  5. braktoon

    Access TransferSpreadsheet problems

    good call, i am looking into this and will let you know how it goes. finding the code to create a new table that is linked to an excel spreadsheet is a little hard though, so if anyone knows off the top of their head i would appreciate it if you could share it.
  6. braktoon

    Access TransferSpreadsheet problems

    also...with a linked object how do i query the excel spreadsheet? is that even possible, i searched high and low and haven't found anything on running a query on a linked excel object. maybe i'm looking in the wrong places, but a few questions come up. for example, what would i use as the...
  7. braktoon

    Access TransferSpreadsheet problems

    thanks for the suggestion, that is one of the solutions i am looking into. it should work, but does anyone know if working with a linked object will slow it down because efficiency is a major issue with this program.
  8. braktoon

    Access TransferSpreadsheet problems

    i am writing an application in access and have to import a lot of data from excel. right now i am using the transferspreadsheet method to import the data to a table, but when i open the table there are fewer records than there are when i open the spreadsheet in excel. the only thing i can...

Part and Inventory Search

Back
Top