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

Table called "Name AutoCorrect Save Failures" 6
DoCmd.Transferspreadsheet - need help in determining Excel range 1
Need formulas for searching for a value in a table and returning row/column name 7
errors while importing txt file 1
Transfer Spreadsheet... setting parameters, etc. 7
AutoCorrect Save Failures 2
Error when using ODBC data source 1
Macro to save word pages separately as PDF and name them according to text in third line 0

Top