Recent content by standenman

Thanks to all for your responses. I will look at it tomorrow.

When I try to rename this field to "ProviderBusinessMailingState" MS access says that it does not follow Access object-naming rules.

The names come from the excel spreadseet that I downloaded. Access is such a fussy little...

Thanks

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

But I an not selecting append. I actually got it to work by creating a totally new MS Access database. Go figure! thanks for your help!

Just so I am clear. I do not have a table in MS Access "waiting" for the date from the excel spreadsheet. But like I said for any other excel file, I do not need an access table: the wizard creates the table.

I understand. When I go to External Data>New Data Source>From File>Excel I choose a target excel file the Wizard takes me through and creates a new table for that excel data - if that target file is another small excel speadsheet. But like I said when I target that large file I get the error...

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

Actually, no. That was what made the code fail: now it runs but appends no records. An old friend used to have a phrase "like a monkey with a beer tab" which I think applies to me - I keep cutting my fingers because I really don't understand how these queries work. I have simply copied from...

Wow. Thanks so much for your keen eyes! Yes, that was the problem!

I tried that - still fails. Weird.

OK. I am about out of gas on this one. My serious of append queries which basically take a flat csv file and incorporate the date into my relational DB seems ALMOST there! Access, however, complains at the last query, saying I have a syntax error in the join operation. First pic is my table...