Recent content by Coach3131

  1. C

    XML import issue

    Thanks Galaxiom! I will look into it tonight/this weekend and see if I can get it set up. I have used VBA a bit with Excel so it is just a matter of learning the objects in Access.
  2. C

    XML import issue

    Looking for someone to point me in the right direction. I am not familiar with XML.
  3. C

    XML import issue

    It should be: Franchise, Player, and Player Status in this particular table... 3 fields
  4. C

    XML import issue

    So how would I get that into an Access table?
  5. C

    XML import issue

    This XML file does not appear to have any style information associated with it. The document tree is shown below. I am getting this error above in the browser. When I import into an Access table, it is not importing any data, but it is creating a field (franchise) that is 16 rows of blanks...
  6. C

    Access vs Excel Feature Question

    I am an experienced Excel user, and now I am looking to take that into Access. One of the tools that I like in Excel is the Web Query feature, but that isn't present in Access, at least not to my knowledge. Are there any suggestions anyone might have to pull data from the web and populate an...
  7. C

    Access Equivalent to Excel Web Query?

    I am looking for something that will be faster and not have intermediary steps. Using Excel Web Queries, I would have to store the information first into an Excel file then push it to Access. I would rather have it pushed directly to temp tables in the database.
  8. C

    Access Equivalent to Excel Web Query?

    I am writing to get suggestions on populating a database table from web data. For example, if I wanted to get stock price information or sports stats or something, what would be a good way to go about it? With Excel, I can use the Web Query feature for data.... but what is the equivalent in...
  9. C

    Access 2010, Web Tables/Relationships, & Excel Imports

    In Access 2010, it provides the ability to create a Web database. Thus, there is special rules to make a normal Access Database, Web Compliant. I am looking for best/practices to keep a database Web Compliant and be able to do Excel Imports of massive data. Basically, if I have PlayerID table...
  10. C

    Access 2010, Web Tables/Relationships, & Excel Imports

    I am interested in knowing the best practices as it relates to setting up a web database and being able to import data when the lookup field is being as a number field. I can get an import to work correctly if I leave off the lookup field, but that becomes a problem when there are a lot of rows...
Back
Top Bottom