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!

Recent content by braktoon

  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...
See more

Part and Inventory Search

Back
Top