Access 2007 Issue. 2 in 1

[DThib]

Hello all,

I have several databases that hold different segments of an items history. 2 of these databases have parts of the information. I run this in Access and I get a table with my specs.

I need to export the Excel file of this and then attach the database to update the query.
When I first export to start the second part of this process, It gives me NAME?? and it tells me I have an invalid character.

What is going on?
The database queries I am building form work separately.

DThib

 

[DThib]

The error message is:

[DataFormat.Error] " is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.

DThib

 

[xenou]

Hi, it isn't clear from the description what you are doing. Can you explain the steps again? Thanks. What are you running? What are you exporting? How are you doing it? Also you might as well give your best guess as to how the name [DataFormat.Error] is related to your process (if you have any idea at all).

 

[DThib]

Hi Here is the SQL Code:

SELECT [1st_Query].EntryID, [1st_Query].SPR, [1st_Query].ProductGroup_cust, [1st_Query].Product_HW_Disp, [1st_Query].Product, [1st_Query].Summary, [1st_Query].CustomerAccountSAP, [1st_Query].SerialNumber1, [1st_Query].DateSPREntered, [1st_Query].AssignedTo_Name, [1st_Query].SPRStatus, [1st_Query].DateAssigned, [1st_Query].ResolvedDate, [1st_Query].VerifiedBy_Name, [1st_Query].VerifiedDate, [1st_Query].DateClosed, [1st_Query].DaysOpen, [1st_Query].FailureInvID, [1st_Query].Symptom, [1st_Query].AssignedToVerify_Name, [1st_Query].Country, [1st_Query].State, [1st_Query].Complaint_Type, [1st_Query].[Complaint #], [1st_Query].Date_ResolvedBy_MoYr, [1st_Query].Date_OccuredBy_MoYr, [1st_Query].[Function Dept], [1st_Query].ConsoleUsed, [1st_Query].CorrActionReq, [1st_Query].CorrActionID, [1st_Query].DurationOfUse, [1st_Query].[01_dbo_vSPRDetailExtended].DateReadyForFI, dbo_vFI_Data.PrimaryRootCauseLevel1, dbo_vFI_Data.PrimaryRootCauseLevel3FROM 02_Impella_SPR, dbo_vFI_Data, 1st_Query;

I am pulling a query (the one I am speaking about) that takes 1 query that pulls from 2 databases for more information than this query will take, (1st_Query),
I am adding another query from another database and taking some of that information.

The code runs and produces a table in Access, I then save the change. Wen try to export to Excel 2016 and either say to format or not. It will end in this error and the about 13 rows of a potential 27,000 with NAME??. I try to add the database and I get the error above.

 

[DThib]

Sorry for the misspelling

 

[DThib]

Any ideas?

 

[xenou]

Hi, the SQL you posted has no FROM clause. It doesn't appear to be valid SQL.

 

[DThib]

Ahhh,

So FROM should limit the rows chosen to add in the query?

Sorry, I am new to coding in Access. I usually work in Excel

Can you give me, at least an example of what a FROM statement should be structured?

 

[Joe4]

No, the FROM clause tells the query where the data is coming from (Tables or Queries).
You cannot "SELECT" something from nothing. Every query MUST have a FROM clause.
The WHERE clause is where you would place any criteria/filters.

Have a look at this here: https://www.w3schools.com/sql/sql_select.asp
If you click clicking Next a the bottom of the page, it will come to other things, like the WHERE clause.

 

[DThib]

Thank you!

That makes sense.
I will work on that.
Are these 2 elements required to be on 2 separate lines? How are they suppose to end (.,?