Search results

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

I did not think I was ignoring your approach save the starting out with transferspreadsheet. Thank you for all the help you have given me. I appreciate it. OK solved it. Changed append query to: INSERT INTO tblClient ( Name, SSN ) SELECT DISTINCT Name, [Social Security Number] FROM...

OK so the slow slog begins. I am seeking to enter a group of client medications. Here is the table organization: In creating a sequence of append queries I am starting with creating a record in tblClient with name and SSN. i have created a "mastertable" via code in this form: Private Sub...

I'm just a dumb lawyer -I don't really know what you mean about "list of requirements" but I am trying to analyze Ken's code. Series of append queries, going to see if I can figure out proper order as it would apply to my tables.

The addresses for contacts is complicated. Many years ago I followed the example of a contacts DB in an Access book. I am not sure it was the right strategy. because it made it very complex. Basically addresses connected to contacts via a switching table. This, however, was so annoying in...

Well the idea was that if I had just a contacts table - which includes minimal information folks and clients where I need lots of information. so for a "Doc" contact I would have lots of null fields.