Recent content by Coach3131

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.

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

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

So how would I get that into an Access table?

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

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

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.

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

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

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