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 bkrike 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: *

  • Users: slowmike
  • Content: Threads
  • Order by date
  1. slowmike

    DTS Multiple Excel Sheets

    I am having a problem with getting my DTS package to import multiple sheets from an Excel workbook. I have set up a connection for each sheet, so my DTS package works if there are 10 or fewer sheets, but I have no way of knowing if the workbook has more than 10 sheets. Also, if there are fewer...
  2. slowmike

    Change Field Type When Importing Excel into Access

    I am trying to import an Excel spreadsheet into Access, but I cannot change the field types that Access automatically assigns to each field. Apparently if the first few records are populated with numbers, it calls that field a number, but if there are alpha characters in that field for...
  3. slowmike

    Export Dynamic Table to Text-Tab

    I'm trying to export a number of tables with a variable number of fields and field names to a tab-delimited text file using VB code. If I use the TransferText method, I can only export to a comma-delimited text file if I do not have an export spec. I tried to create an export spec on the fly...
  4. slowmike

    How to Maintain Row Order when Exporting

    I want to export a table from Access to Excel without changing the order of the rows in the table. However, when I export it (either manually or using OutputTo) the order of the rows is different in the spreadsheet than it is in the table, even though I have the table indexed. Is there a way...

Part and Inventory Search

Back
Top