Search results

  1. C

    Quickly copy Excel rows to Access

    It's the row number in the Excel sheet. I wonder if I could use the row function on Excel somehow in the SQL statement?
  2. C

    Quickly copy Excel rows to Access

    Right - the row # needs to be tied to another column which tells me the Excel worksheet. So row #1 might repeat many times.
  3. C

    Quickly copy Excel rows to Access

    No, and would be difficult since the PK would be based on several fields.
  4. C

    Quickly copy Excel rows to Access

    Works like a charm. Follow-up question is how to add a running "row" # to the SQL statement in case a specific record needs to be audited. Thanks!
  5. C

    Quickly copy Excel rows to Access

    Thanks - I'll try that!
  6. C

    File Dialog with Default Value that has Spaces

    It's just the !, not really "!". But also these are the filenames that a client sent us.
  7. C

    File Dialog with Default Value that has Spaces

    VERY VERY WEIRD!!! Thanks for trying!!!
  8. C

    Quickly copy Excel rows to Access

    PS, I believe you can export a recordset to a specific Excel location (using recordsets?)... so this would go the other way.
  9. C

    Quickly copy Excel rows to Access

    Hello - I have an Excel workbook that has a complex structure, and so I can't just import the whole thing into Access using VBA. Rather, I want to import certain rows into a pre-existing Access table (all Cols exist in Access, but all Cols may or may not exist in Excel). I have coding working to...
  10. C

    File Dialog with Default Value that has Spaces

    Very strange. I would end up getting "Only.accdb". PS, I also have an "!" in the beginning of the final folder name (e.g., \TDS Economy\ in your example, would be \!TDS Economy\, but that shouldn't impact things I would think.
  11. C

    File Dialog with Default Value that has Spaces

    Hmmm... the filename has a "!" at the beginning... would that impact things?
  12. C

    File Dialog with Default Value that has Spaces

    Hello - using a file dialog (generally works fine) but it truncates a file name when I put in a default value with spaces. I've tried Chr(34)+DefaultPath+Char(34) and also tried replacing any spaces with %20. No luck so far. Any suggestions? Thanks!
  13. C

    Filtering not working but Allow Filters = True

    Hello - I have a table as a linked table connected to SQL server. If I open the table directly in Access (not in a form), I can filter/sort. But if I open it in a form (where "Allow Filter = True"), I can't filter or sort??? What am I missing? Thanks!
  14. C

    Multiple similar relationships?

    Yes I tried the drag method with no luck... it's okay for now based on other DB design items.
  15. C

    Multiple similar relationships?

    I'm trying to use the somewhat usable GUI of sql server - Access GUI is much easier but I'm building the back-end in sql server.
  16. C

    Multiple similar relationships?

    Yes, thanks. This would be an alias issue in SQL server. But can I create aliases just using the GUI of sql server or do I need to use T-SQL? Thanks.
  17. C

    Multiple similar relationships?

    Hello - any suggestions on this item please? Thanks!
  18. C

    Multiple similar relationships?

    Hello. Let's say I have a table of colors (red, white, blue, etc.) and another table that has People's names, their favorite color, and their least favorite. I can't seem to set up TWO (or more) relationships between the table of colors to the Fav field and the table of colors and the Least Fav...
  19. C

    Access + Adobe Performance

    Hello - I'm using Access VBA and the Adobe SDK to pull words from searchable PDFs. Works great (most of the time) but with larger PDFs, it seems to hit a performance wall where it will be extracting the same page for a long time. Sometimes, after 2 mins, it will move on. Other times it crashes...
  20. C

    Using DAO to connect to SQL server in Excel

    Okay -- off to ADO I go... Thanks!
Back
Top Bottom