access report from excel file

[codrutza]

Hello
I have a link from Excel to access which creates an (Excel) table in access and we have built a report in access, but every time we update the excel file, the type of some fields in the table changes and we can't print the report properly. (I have numeric fields, text fields, date, alfanumeric....I tryed to make them all type text but they change when link)

I have no experience in Access or VBA but I want to do the link (or something else) between Excel and Access programatically somehow, to be sure that we can print the report from Access,no matter the type of data in Excel.

We want as well to keep all the records in an Access table, and delete the content of Excel file. I have created an append query but when we add records to the excel file, I get error like Numeric overflow so this doesn't work neither

Then we want to be able to bring back a record in order to modify it.

Maybe I ask too much but can somebody help me and give me some code I could write in VBA?

Thank you

 

[GingerR]

These are typical problems when importing data from other sources. Something you might want to try is to import the Excel data into a "temp" table, then write an append query to add that data into an Access table which has the formatting you want. So, either write an append query to add the linked Excel table to another Access table, then use THAT Access table as the basis for your report, OR import the data in (vs. Linking) and do the same thing. It just takes some fiddling around to get what you want. Try doing that and let us know how it goes.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html