compatability issues

  • Thread starter Thread starter Antonio
  • Start date Start date
A

Antonio

With the help of the TransferSpreadsheet Action I linked a
table in my database with a spreadsheet that sits in my
documents folder. Everything seems good...as soon as I add
data to the spread sheet it updates the linked table in my
database...the problem is with data types...there are 3
fields in the spread sheet that contain alpha-numeric
codes (ie...V907.3, 3,ff,mm,7, etc) when open the linked
table there are error's in those spaces that contain an
alphanumeric code (error is #NUM!). When I attempt to
modify the table cell properties (switch the data field to
number, text, or whatever) it states that I can not change
the properties of a linked table....
I deleted the link, changed the properties on both sides
(Spread sheet and Access Table), but no matter what I do,
when I excecute the macro the 3 fields display with the
same #NUM! errors as previously....
I cant figure out what I am doing wrong....
 
Access bases the field formats on the first few Excel
records. What you need to do is insert a dummy first
record in your spreadsheet that is used for formatting.
put a date,text, or number in that cell. Access will base
the formatting on that first line in your spreadsheet.

Jim
 
Back
Top