Name AutoCorrect Save Failures

J

Jeefgeorge

When I run a TransferSpreadsheet command, a [Name AutoCorrect Save Failures]
table is created.

Object Name: BidTabData
Object Type: Table
Failure Reason: Could not save the object
Time:

Code:
....
Tble = "BidTabData"
Path = ahtCommonFileOpenSave...
CurBid = 1
Do While CurBid <= 7
Rnge = "Bid" & CurBid
DoCmd.TransferSpreadsheet acImport, 8, Tble, Path, -1, Rnge
CurBid = CurBid + 1
Loop
....

I think this table is created since the range is 250 rows long, but some
rows are blank. Some spreadsheets have 7 rows, some have 100. I used a range
of 250 rows because that is an extreme max to insert. The blank rows are not
imported, because no primary key is present. I think the error is because
these blank rows are not added to the table. Is there a way to not flag not
saving blank rows as an error? Or is there something else generateing this
table?
 
J

Jeefgeorge

Thanks, Worked Great


Klatuu said:
Turn AutoCorrect off. Don't use it. It is buggy and causes problems.

You may want to read the info at this site:
http://allenbrowne.com/bug-03.html
--
Dave Hargis, Microsoft Access MVP


Jeefgeorge said:
When I run a TransferSpreadsheet command, a [Name AutoCorrect Save Failures]
table is created.

Object Name: BidTabData
Object Type: Table
Failure Reason: Could not save the object
Time:

Code:
...
Tble = "BidTabData"
Path = ahtCommonFileOpenSave...
CurBid = 1
Do While CurBid <= 7
Rnge = "Bid" & CurBid
DoCmd.TransferSpreadsheet acImport, 8, Tble, Path, -1, Rnge
CurBid = CurBid + 1
Loop
...

I think this table is created since the range is 250 rows long, but some
rows are blank. Some spreadsheets have 7 rows, some have 100. I used a range
of 250 rows because that is an extreme max to insert. The blank rows are not
imported, because no primary key is present. I think the error is because
these blank rows are not added to the table. Is there a way to not flag not
saving blank rows as an error? Or is there something else generateing this
table?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DoCmd.Transferspreadsheet - need help in determining Excel range 1
Table called "Name AutoCorrect Save Failures" 4
errors while importing txt file 1
AutoCorrect Save Failures 2
Transfer Spreadsheet... setting parameters, etc. 5
Multiple Range TransferSpreadsheet 5
Docmd.Transfertext 'Autocorrect' error 2
Error while importing text file; 1

Top