Search results

I am trying to make a table with this code: SELECT NPIMonsterPared.NPI, NPIMonsterPared.[Entity Type Code], NPIMonsterPared.[Provider First Name], NPIMonsterPared.[Provider Middle Name], NPIMonsterPared.[Provider Last Name (Legal Name)], NPIMonsterPared.[Provider First Line Business Practice...

I am trying to import a very large Excel file - 205,000 KB. I click on "new data source" and select my excel file and go through the wizard. This is what I get at the end. Is this related to the file size? Is there another way?

I have a publically available excel spreadsheet of US hospitals. The spreadsheet provides a plethora of rows for each entry - I am not really sure why. But I want just one row for each hospital - one row per Facility ID. Can anyone help me do this?

I am trying to create VBA code that will download a template pdf file from my online adobe acrobat account and fill it with MS Access data. It works file when I have the target file on my desktop. Private Sub Command85_Click() Dim TemplateURL As String Dim DownloadFolder As String...

I see on the homepage there are many glowing reviews. My experience as less than spectacular: snarky and condescending attitude. Bet you won't give the chance to post a review on your homepage!

I have created a form in JotForms in which my clients can input details about the medications they are currently taking (name, dosage, side effects, etc). So any given client could be taking 1 or 20 medications. This would correspond to a table in my Access DB, tblMedications where each...

I am creating a data entry "flow" so have a virtual assistant interview my new client and enter data we need. I use MS Access and I do this myself, just going from table to table. My data, of course, is organized into tables with a variety of relationships - one to many, many to many, etc. I...