Search results

OK, I'll stick with Decimal(9,6). Thank you everyone.

Hello Access World, I am storing Lat / Long from GoogleMaps API in SQL Server. It is recommended to use the Float Datatype to store Lat / Long, however, when I use Float MS Access presents me with the following error when I open the Linked Table. When I store Lat / Long as Decimal(9,6)...

Understood. Thanks everyone.

Thanks Isaac. The Import Flat File was recommended by this SQL Server teacher on YouTube(URL below), who has courses on Udemy. He advises to use the Flat File Import for .csv files. He does cover the Import Data wizard for Excel files later on in the video. Import Tutorial

Thank you Tom. I assumed it was Unicode due to the Accent on the e and SQL Server not being able to import it using the Flat File import Wizard. I see now that the e with an accent is still part of the ANSI character set. Yes, MS Access link can process the file correctly and I used SSMA to...

The file contains accents in the Province Field as shown in the first post. Waste Class is a field that does not contain any special characters but is longer than 255 so that is probably the truncate message. I was in a rush Sonic so I just decided to go the route that is slower but worked...

Thank you Isaac. The codepage feature is available in the Import Data Wizard. Unfortunately, it's not available in the Import Flat File Wizard which is much simpler. That being said I am getting an error using the Import Data Wizard. I decided to import into MS Access and then use the SQL...

Exactly, that is what makes this puzzling. I consider this to be a bug. Note, it only starts to falter when you increase the number of Numerical Digits.

Thank you George. We actually met in PADU back in the day.

Thank you MarkK and George for your feedback. I was able to figure out the cause. When the Field Format in Excel is General the MS Access Link Truncates the 2nd Decimal Digit. When the Field Format is Number with 2 decimals the MS Access Link to the Excel file shows the 2nd Decimal Digit...

Hello Access Forum, I am unable to import Excel into my SQL Server due to the error 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) 1) By running EXEC sp_enum_oledb_providers I can see I have Microsoft.ACE.OLEDB.12.0. on my machine. 2) It's...

Hello Access Forum, I imported a .csv that contains special Unicode characters using the Import Flat File wizard from SSMS. The .csv shows the Unicode characters properly but the output of the import in SQL Server does not. Please see the below screenshots. I have attached a sample .csv...

I believe the issue is with my Excel. The Excel Link doesn't show the 2nd digit and that is where I think he problem originates. When I imported using SQL Server as a .CSV the 2nd digit appears

It's 255 George. I also tried it with Long Text. Same results on my Machine.

I am running MS Access 2019. What are you running MarkK? I imported using the Import Wizard.

Hello Access Forum, I have encountered strange behavior between Excel Data and MS Access. I have an Excel field that contains strings and numbers that contain decimals. When I link to this Excel sheet or Import it in MS Access the last digit from the first number is truncated. (See below...

Thanks for the suggestion Pat. Splitting the WasteClass into multiple components make sense.

Thank you CheekyBuddha and everyone else who contributed to this thread.

Thank you for everyone's responses. The Where Predicate on the View can get complex (See code below) depending on the search criteria from the user but what I am gathering is I can link the View and still create the Dynamic SQL on an Access Query. MS Access will send the below Access Query...

Hello MS Access Expert, Are there any advantages to a Stored Procedures vs. a Dynamic SQL Pass Through Query based on a View? Suppose I have a View and I need to include a user defined Parameter on the View from the MS Access Front End. I can create a Pass Through Query with a Where Clause...