Search results

  1. G

    Woes importing Excel into SQL using SQL Server Import and Export Wizard

    Use a different delimiter. eg a tilde (~) or a pipe (|)
  2. G

    Woes importing Excel into SQL using SQL Server Import and Export Wizard

    What about putting an easily recognised dummy record at the top then deleting from the table afterwards?
  3. G

    Woes importing Excel into SQL using SQL Server Import and Export Wizard

    Most importing processes look at a small number of values in the first few rows and take a guess at the datatypes. It might help to sort the data in the spreadsheet so the datatypes of values of the first rows are absolutely unambiguous.
  4. G

    Woes importing Excel into SQL using SQL Server Import and Export Wizard

    You could convert the spreadsheet to csv and use BULK INSERT or bcp They are very configurable with format files but poorly documented and infuriatingly finicky. BCP can be made to generate a Format file but I found I had to manually edit it anyway because I was stuck with importing text. I...
  5. G

    Has God Ever Visted Plagues?

    Has God ever visited Plagues? I have searched everywhere but I can't find Plagues. What country is it in?
  6. G

    Has God Ever Visted Plagues?

    Maybe they are worried about their voice being sent to a server to be converted to text? Some services even include humans to deal with the unrecognisable content.
  7. G

    How do you delete a recordset field?

    The DAO Recordset Fields Property is Read Only. The Delete Method of DAO Fields Collection applies only to TableDefs.
  8. G

    Extract last 2 words of a string

    Concatenating the search character onto the end (or beginning in the case of InStrRev) of the searched string avoids both these problems. The advantage of using engine functions over user defined functions is performance while the advantage of the UDF is the ability to include refinements like...
  9. G

    VBA alternative

    Ejecting VBA because it can do damage is like cutting off an arm cure a broken fingernail. Any kind of code is a threat. Where I work we block anything that isn't known about by a central permissions system. Any executable code needs to be signed or fingerprinted and whitelisted. VBA Code...
  10. G

    IIF with LIKE in an unbound text box

    Sounds like you are faced with working around badly structured data. Pat is probably on the mark. My answer earlier was based entirely on reading these two lines.
  11. G

    IIF with LIKE in an unbound text box

    Count will give the same answer to 1 or 0. Try Sum()
  12. G

    Bicycle tire advice?

    For mixed on and off road use on a mountain bike, a "hard pack" tyre is good. They are designed for compacted gravel. My favourite on my 26 inch unicycle is the Maxxis DTH 26 x 2.15. Very light weight especially the foldable bead model. (This has a kevlar thread instead of wire for the bead so...
  13. G

    Bicycle tire advice?

    575 is the Effective Rim Diameter in millimetres. It is normal "26 inch" tyre. This is the 26 inch with decimal width. There is a rare ancient type that uses fractional inch widths that is very different and won't fit your rims. The width of the tyre (the 2.0) should be between 1.4 and two...
  14. G

    How to add a module to a form when you use the create form method

    A database that requires design mode at runtime is a flawed design. I suggest you post back describing the structure of your tables as your post is ringing normalization alarms.
  15. G

    Named Parameter Problem

    The wildcard character for ADO is the percent sign (%) .
  16. G

    Form Component Naming Prefix

    You hit the nail on the head there. It is largely a fetish, particularly among Access developers. Some get really obsessed with it. It is also popular in Visual Basic but it is rare in other languages. It was popularised in Access as slightly different flavours by Greg Reddick and Stan...
  17. G

    How to strip back account numbers

    If you don't care about leading zeroes and just want the numerals at the beginning: Val(fieldname) Two catches. If the numerals are immediately followed by "e" and some more numerals it will be treated as exponential notation. Val("123E45xyz") = 1.23E+47 Numbers over 2^31 -1 (2147483647) will...
  18. G

    Module to open ADO connection at apps start

    Basically create a user defined function in a Standard Module and return the Connection Object. I've done it using a class with a Private Collection (or Dictionary) of connections presented as members of the class. (I used to have two servers at the time before I linked them and ultimately...
  19. G

    SAGE - SQL - ACCESS LINK

    You probably just need to get the Sage ODBC driver for the upgraded version.
  20. G

    BE tables to SQL Soon.

    I am the dba where I am employed. (And a network admin too.) Small shop with big resources. It is like heaven since they put on a network admin specialist and let me focus on the databases. The incredibly fine granular permissions on SQL Server means is easy to give a login quite considerable...
Top Bottom